Importing Data - 2

[Risky Dave]

Hi,

Related to my previous posting:

I am importing data from one workbook to using a macro to automate the
process.

I can move the data ok, but when closing the source workbook from the macro,
I am asked:

a) if I want to save changes
b) "There is a large amount of on the Clipboard. Do you want to be able to
paste this information into another program later?"

I can do a) (Workbooks("nnn").Close SaveChanges=False), but cannot find the
syntax to close the pop-up about the Clipboard. I do not want to make this
data available once the workbook is closed.

Any help would be appreciated.

TIA

Dave

 

[Joel]

Try this

Application.DisplayAlerts = False

 

[Angelika & Rocky Mckinley]

You could try copying something small to the clipboard right before closing
the workbook, that way the Os won't ask about the large amount of data on
the Clipboard.

Regards,
Rocky

 

[Gord Dibben]

Application.CutCopyMode = False will clear the clipboard.


Gord Dibben MS Excel MVP