Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing:Data Connection Wizard Doesn't see Source Data - No Impo | Excel Discussion (Misc queries) | |||
Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
Importing data: OLE DB and data link properties dialog | Excel Programming | |||
Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
Importing data, then adding data to the new spreadsheet.. a conund | Excel Discussion (Misc queries) |