Export Excel + VBA to Webpage
Posted this yesterday in a journal already, but I still didn't fix it (nobody helped -.-'), so here it is again! ^^
-----------------
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!!!!!
-----------------
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!!!!!
I just want to export to a website, but when I open the website the button to start the program does nothing, while it does work in Excel itself...
Maybe it's only for cell interaction not vba :)