Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have two questions.
I receive a .csv file of data that I open, do some manipulation, and then copy all of the data into another workbook. I want to close the worksheet containing the .csv data and do that with Windows("Printing.csv").Activate ActiveWindow.WindowState = xlMaximized ActiveWindow.Close The problem I have is that a message box about "A large amount of data on the clipboard" comes up and I have to click on "No" to close it. Is there a way to pass the "No" with the close command and avoid the message box entirely? A little later in the macro, I print a worksheet that has been modified by several of the preceding steps. The worksheet is not active (actually, I'd like to hide it) but to print it, I have to make it active, then print it, then activate a different worksheet. Is there a way to print an inactive and/or hidden worksheet? Any suggestions would be appreciated. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to save a workbook to an active Web Page? | Excel Discussion (Misc queries) | |||
Printing a workbook but not getting page set-up results | Excel Discussion (Misc queries) | |||
printing multiple page workbook | Excel Discussion (Misc queries) | |||
closing active windows without saving changes | Excel Programming | |||
Need help for closing the active worksheet only under conditions | Excel Programming |