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 |
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) |