Importing Data - 2
 

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

Importing Data - 2
 

Try this

Application.DisplayAlerts = False


"Risky Dave" wrote:

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

Importing Data - 2
 

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


On 12/30/07 5:37 AM, in article
, "Risky Dave"
wrote:

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

Importing Data - 2
 

Application.CutCopyMode = False will clear the clipboard.


Gord Dibben MS Excel MVP

On Sun, 30 Dec 2007 05:37:03 -0800, Risky Dave
wrote:

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