Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Visual Basic run-time error when printing from web application...
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Printing with Visual Basic Editor Problem | Excel Discussion (Misc queries) | |||
Visual Basic macro run time error(13) type mismatch | Excel Discussion (Misc queries) | |||
How do I protect Visual Basic for Application Code | New Users to Excel | |||
Printing in Visual Basic | Excel Discussion (Misc queries) |