
We want to help you help us to do it by reading this: Before you ask a question. You seem to be having problems already and it will only be harder next time you want to make a change, unless you bite the bullet now. This is not criticism - I know how these solutions evolve, but sooner or later you need to take a step back and look at what you're trying to achieve. Adding content to a 'Word Template' (I presume you mean a Document based on a Template) and then moving it to another 'Template' also smacks of a lack of design. Do you have formatted data in the database or are you just moving text around?Īside from clipboard issues, running multiple processes - each accessing the same database, and each with its own instance of Word - sounds like poor design. In this case there is no user so the same concerns may not apply, but the clipboard is an artificial intermediate storage mechanism and it's hard to see how using it helps. The clipboard belongs to the user and should not normally be used in VBA. RE: VBA Clipboard Manager combo (TechnicalUser) 3 Feb 15 20:10 Any help or direction on this would be greatly appreciated. If you know of anything or have done anything similar, please add a response.

'copies the selection and returns the index on the clipboard
#Microsoft office clipboard manager windows#
In normal Windows I ctrl-c a range of cells in Excel and then ctrl-v to paste them into Word. I know that the Office clipboard allows for multiple items but there is no interface with it (aside from accessing it through the command bars) that would allow me to know the index of what was being copied making it impossible to use. System Clipboard option transfers a selected clip to windows clipboard which will mean that Right Click > Paste will now paste that selected clip as if it was currently held in the clipboard or simply as if it was the last thing copied. I would then be able to retrieve that item for pasting by providing the index (rough example below). Ideally, I'd like to be able to create a clipboard object and get an index returned when I copy to it.

You can still use the Ctrl + X, Ctrl + C, and Ctrl + V keyboard shortcuts to cut, copy, and paste recent data. This should allow me to run multiple processes without getting incorrect content from a shared clipboard. Just use the Windows key + V keyboard shortcut and the clipboard panel will open. I'd like to find some kind of clipboard manager with an object model I can use from Access VBA. If I try to run more than one, I run the risk of incorrect data being pasted to the wrong Word document. Because of the way that the clipboard is used I can only have one of these processes running on a machine at any given time. Current process uses MS Access, MS Word and the Windows clipboard to create correspondence.
