Copy and paste between workbooks

[mcinnes01]

Hi,

I have and updater module that sits on a server and essentially the purpose of it is to copy and paste a range that comes from an SQL data link, to another spreadsheet that sits on the intranet.

The problem I am having is that the range isn't being pasted to the other spreadsheet when I run the macro.

It seems to work when I step through the macro, but not when I run it.

This is the bit of code that does the copy paste function:

Please Login or Register  to view this content.

[mcinnes01]

further to my previous post I have played around with various copy methods and have identified the problem, but cannot resolve it.

Basically the spreadsheet that is opened and where the data is copied to, has a custom save routine that is affecting the save. I have removed the close and on the workbook I can see the data has been copied, but I think the customsave routine then doesn't actually save the book and so when it closes the copied data is lost.

This is the code I think affects the save but I can't work out how to negotiate the custom save when the updater runs?

Please Login or Register  to view this content.

this is the code I can't remember where I found it, but it is required for disabling cut copy paste and a few other things

Please Login or Register  to view this content.

Please Login or Register  to view this content.