I had an idea, and I was just wondering if it's possible. I know how to export an Excel sheet as an HTML document so that web users can view it, change it, and save it as another Excel document. However, I noticed that with this method, any VB scripts used in Excel are not ported to the HTML document.
Is it possible to create a web page that will allow a user to view, use, and edit information from the Excel sheet, including any interactivity therein (including any drop-down menus, check boxes) PLUS have functioning VB scripting, AND will also save any changes to the ORIGINATING Excel sheet, NOT a new document?
My guess would be that this would involve an insane amount of scripting in ASP or Java or Perl or some other scripting language compatible with HTML, but is such interactivity possible?
Is it possible to create a web page that will allow a user to view, use, and edit information from the Excel sheet, including any interactivity therein (including any drop-down menus, check boxes) PLUS have functioning VB scripting, AND will also save any changes to the ORIGINATING Excel sheet, NOT a new document?
My guess would be that this would involve an insane amount of scripting in ASP or Java or Perl or some other scripting language compatible with HTML, but is such interactivity possible?