Printing through the Excel Object Library
 

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

Printing through the Excel Object Library
 

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.

--
Regards,
Tom Ogilvy

Shay Friedman wrote in message
...
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