Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
GWS GWS is offline
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visual Basic Error Run Time Error, Type Mismatch Meg Partridge Excel Discussion (Misc queries) 12 September 10th 08 06:10 PM
Printing with Visual Basic Editor Problem Meader Excel Discussion (Misc queries) 3 May 30th 07 08:55 PM
Visual Basic macro run time error(13) type mismatch Paul Excel Discussion (Misc queries) 0 October 25th 05 07:28 AM
How do I protect Visual Basic for Application Code Zagrijs Venter New Users to Excel 6 August 5th 05 09:24 PM
Printing in Visual Basic bjh96 Excel Discussion (Misc queries) 1 June 17th 05 08:22 PM


All times are GMT +1. The time now is 12:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"