Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Run MS Excel File With VBA Form & Modules On Website

Status
Not open for further replies.

DDTiff

MIS
May 29, 2002
48
US
Hello All,

Do you know if it is possible to run the MS Excel file with VBA forms and modules embedded on a Website? I uploaded the MS Excel file with VBA forms and received an error message when I tried to run it directly from the Website. The error message is as follows: "Run-time error 91 Object Variable or With block variable not set"

I have no problem running the file using MS Excel application. That brings me to the question of whether it's possible to run a MS Excel file or any MS Office file with embedded VBA forms and modules directly online.

I truly appreciate your time and help in advance. I look forward to hear from you soon. Have a good day.

Diem
 
You can run 'em online but there are slight differences. Some of the "shortcuts" (especially for range manipulation)that can be used in excel, cannot when run on IE. Basically, it's a bit trial and error but in general, try and explicitly state EVERYTHING so instead of
range("A1").value = 1
use
sheets("Sheet1").range("A1").value = 1

etc etc

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
 
Thank you for response, Geoff. I tried your suggestion, but I ran into error when I ran the file on MS Excel Application. I think I should give you more detail of the functionalities that I currently have, so you can help me.

The VBA Excel file consists of three forms, when a users double clicks on any cell within column "E", a form with an inputbox and 2 command buttons will pop up asking the user to enter a number into the inputbox, and then click the "OK" button. The new value will replace the old one, and automated calculation functions will calculate new values for column "F" and "G".

I ran into an error message when I clicked the "OK" button after I entered a number into the inputbox, which is Run-time error 91 after I uploaded the Excel file on my website. Can you please help me? Thank you.
 
Please post the code - I may or may not be able to help as I havn't done much programming for use on the web

Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top