Excel with VBA to a Webpage
•
23 Jun 2008, 11:56
•
Journals
I finished the archivingsystem in VBA I wrote a few journals about earlier. Now I want to export my program (being started by a button on an excel sheet) to a webpage, but it won't work.
Button code (VBA) from the main page:
To make it clear for you guys:
The program starts at Home.form (renamed from Form1.form). I've made a button in an excel sheet with the code you've just read, opening the home form. When I click it in Excel the program starts, but when I click it when I've exported the Excel sheet to a webpage the program won't start.
When I publish my Excel file as a webpage, I indeed get the excel sheet with the button as an activeX element, but when I click the button nothing happens. At first I thought the VBA code wasn't exported to the webpage together with the excel sheet, and I was right. I edited the published page with excel, and noticed that the forms and modules weren't there. So I copied and pasted them in my webpage file (under forms and modules folders ofcourse, like in the original document), but still the button won't work. I've tried giving the button a macro, giving it VBA code, both didn't help.
PLZ HELP MEEEH!!!!!
Button code (VBA) from the main page:
To make it clear for you guys:
The program starts at Home.form (renamed from Form1.form). I've made a button in an excel sheet with the code you've just read, opening the home form. When I click it in Excel the program starts, but when I click it when I've exported the Excel sheet to a webpage the program won't start.
When I publish my Excel file as a webpage, I indeed get the excel sheet with the button as an activeX element, but when I click the button nothing happens. At first I thought the VBA code wasn't exported to the webpage together with the excel sheet, and I was right. I edited the published page with excel, and noticed that the forms and modules weren't there. So I copied and pasted them in my webpage file (under forms and modules folders ofcourse, like in the original document), but still the button won't work. I've tried giving the button a macro, giving it VBA code, both didn't help.
PLZ HELP MEEEH!!!!!
read again
U know anything I could do to make this work?
i understand what you want to do
i have no idea how to do it as i never worked with that before
I wish you good luck
http://www.helpmij.nl/forum/showthread.php?t=362688