Run VBA Excel File On Internet Explorer
Hello All,
Can you please help me with the following problem? I would like to thank you in advance for your time and help.
I have a VBA Excel file that when a user double clicks on a cell within the Column "E" for example, a form with inputbox and two buttons would pop up asking the user to enter a number into the inputbox and then click the "Ok" button on the form. The new value will replace the old one, and an automated calculations functions will automatically calculating the new values for column "F" and "G".
Can you please tell me if it is possible for me to perform the same type of functions mentioned above once I upload the VBA Excel file on my Website using Internet Explorer Browser? I already uploaded a test VBA Excel file with the same capability, and I got an error message when I click the "OK" button after I entered a number into the inputbox. The error messsage is as follows: "Run-Time error 91. Object Variable or with block variables not set".
Again, thank you for your time and help. I look forward to hear from you soon.
Diem
|