Printing through the Excel Object Library

  • Thread starter Thread starter Shay Friedman
  • Start date Start date
S

Shay Friedman

Hi,

My target is quite clear:
1) Open an excel workbook.
2) Print it to a file
3) Copy the file to a new location

Pretty simple, huh? Well, I found it to be a bit tricky.

I am able to automatically do the workflow mentioned above but something is
missing...
In the MS-Word Object Library, the ApplicationClass has a property which is
something like BackgroundPrintingStatus... when that becomes -1 I know that
the printing actions is done. I couldn't find this or a familiar property in
the excel library.

My question is - how can I wait until excel finishes to print the workbook
and only then go on with my code?

Thanks,
Shay
 
print it in the foreground (not sure there is a background option in Excel).

Public sub Printit()

set wkbk = workbooks.Open("C:\My Folder\MyBook.xls")
wkbk.Printout
wkbk.SaveAs "C:\My Other Folder\BookBak.xls"
wkbk.Close SaveChanges:=False

End sub

each instruction won't fire until the previous action is complete.
 
Back
Top