VBA for Office Clipboard

[ITChick526]

I am trying to automate an office document. I would like to write some code that will paste everything in the office clipboard in VBA. I keep running into walls. Does anyone have an idea of how I can automate the pasteall function??

 

[fumei]

1. "office document". Word? Excel? PowerPoint?

2. "I keep running into walls. Does anyone have an idea of how I can automate the pasteall function?? "

You can start by posting what code you have tried.

faq219-2884

Gerry
My paintings and sculpture

 

[ITChick526]

This is for a word Document

 

[ITChick526]

The code is not affecting the clipboard at all. It will only paste the first selection over and over again

i.e. Selection.Paste

 

[TonyJollans]

Unless you are using Word 2000, you can't access the Office clipboard from VBA. The Paste method pastes from the Windows clipboard.

Enjoy,
Tony

------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

I'm working (slowly) on my own website