Automation Error with msAccess creating Excel Spreadsheet

[trevor69]

I have this code below to create an excel workbook, it spits out the queries and saves the file in the first procedure, then the next procedure opens the workbook for formatting.

this all works fine on one pc but not another, they have identical office versions (2003), same n/w access, BUT the one that fails is running under Windows 8

On the bad pc it opens 2 copies of excel, both with blank windows (no worksheet displayed), when the code finishes they are still both blank.
the line of code that fails is shown in Italic, as no worksheet is visible it cannot select the worksheet.

Can anybody see what may be wrong with the sub - format_sheets_now()

Please Login or Register  to view this content.

Code continues with lots of formatting...

[trevor69]

fixed it thanks.

Please Login or Register  to view this content.