PDA

View Full Version : howto convert a excel file to a htlm file inclusive macro's



sls
06-02-2008, 05:47 AM
hallo,

How can i convert a excel file to a htlm file and that my macro's and database connection stil work?? Or is this not possible??
Al my macro's are written in VBA.

with friendly greetings,

sls

Oorang
06-02-2008, 11:28 AM
If you make your excel file into an html file you would need to put all your macros in VB script and put the in the new HTML file where you want them. In most cases this will be fairly non-trivial (difficult).

sls
06-02-2008, 11:24 PM
can i do it by copying my vba code in the vb script? Or do i have to rewrite all my code?

wvg, sls

Oorang
06-03-2008, 05:43 AM
Well you can copy/paste your code but it likely won't all work. Remember that vbscript syntax is more abbreviated than VBA or VB. Also remember that the Excel object will no longer be in context, etc.