Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 12th, 2003, 03:39 PM
Registered User
 
Join Date: Nov 2003
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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






Similar Threads
Thread Thread Starter Forum Replies Last Post
Run a MS DOS Batch file from Excel VBA Louh Excel VBA 1 March 4th, 2008 10:02 PM
Internet Explorer cannot open the internet site cathiec ASP.NET 2.0 Basics 1 October 22nd, 2005 01:30 PM
Run .bat file from Excel VBA Harold Hawken Excel VBA 2 June 23rd, 2005 03:03 PM
Access Internet Explorer via Excel VBA tony_813 Excel VBA 2 March 6th, 2005 08:20 PM
vba and internet explorer ken1978 VB How-To 0 January 23rd, 2005 09:11 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.