Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys
I have written a macro which copy the objects to clipboard and paste them into Excel file.
Macro runs fine but some times it give the error Copy to Clipboard Failed .... please refer to the attach Screen Shot .
i am not running too many problems also.
I am using QV10 SR3.
please help........
Do any of the objects have Copy/Move disabled on the Layout sheet ?
Jonathan
It is enabled in each and every sheet object
Try ticking the Document properties > Security > Macro override security checkbox.
This apparantly stops the window that pops ups when you open a document and asks if you want it to be able to access your system. Maybe this is happening behind the scenes.
Jonathan