Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with Object Library | Setting up and Configuration of Excel | |||
Microsoft Word and Excel 11.0 Object Library | Excel Discussion (Misc queries) | |||
Excel 2007 compatability, VBA Reference, MicrosoftOffice12. Object Library | Excel Discussion (Misc queries) | |||
Microsoft Excel 11.0 Object Library documentation? | Charts and Charting in Excel | |||
Microsoft Word Object Library in Excel | Excel Discussion (Misc queries) |