View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sleeping Bear[_2_] Sleeping Bear[_2_] is offline
external usenet poster
 
Posts: 4
Default Closing a workbook and printing a non-active page

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.