G
GWS
I am new to development and having trouble with printing an Excel 2003
application, developed with Visual Basic for Applications v6, from my
website. The application works well and prints fine from my desktop.
Further, it works as designed when I access the file on the internet through
my aol account.
The problem occurs (Run Time Error '91': "Object Variable or With block
variable not set" when I access the application directly with Internet
Explorer (6.0, SP2) and attempt to print by clicking on a CommandButton on
the UserForm displayed for the interactive application. The Visual Basic
code for the CommandButton is ActiveSheet.Printout. The desired print area
is set as the Print Area for the worksheet hosting the application.
If it were not for the fact that it works as designed when accessed through
aol, I would assume it was my lack of experience writing code. But because
it works intermittently, I am at a loss how to troubleshoot further.
application, developed with Visual Basic for Applications v6, from my
website. The application works well and prints fine from my desktop.
Further, it works as designed when I access the file on the internet through
my aol account.
The problem occurs (Run Time Error '91': "Object Variable or With block
variable not set" when I access the application directly with Internet
Explorer (6.0, SP2) and attempt to print by clicking on a CommandButton on
the UserForm displayed for the interactive application. The Visual Basic
code for the CommandButton is ActiveSheet.Printout. The desired print area
is set as the Print Area for the worksheet hosting the application.
If it were not for the fact that it works as designed when accessed through
aol, I would assume it was my lack of experience writing code. But because
it works intermittently, I am at a loss how to troubleshoot further.