Good afternoon,all.
Does anyone know the correct syntaxt to use the htmlconvert function from the html.xla add-in from within VBScript?
This is what I have so far:
set objApp = createObject("Excel.Application"
msgbox("instance of excel created"
//open the document
objApp.Workbooks.Open "\\g\ & dname
//install addin
objApp.AddIns("Internet Assistant Wizard".Installed = True
msgbox("instance of add-in created"
result = htmlconvert(objApp.ActiveWorkbook.ActiveSheet.usedrange, False, False,False, 1252, "\\g\intranet\assets\htmlpages\" + newFileName)
msgbox("convert finished"
Everything works up to the line that begins with "result=".
I have tried objApp.htmlconvert, but that doesn't work either.
Any ideas, references, resources, or war stories would be greatly appreciated.
Kathryn
Does anyone know the correct syntaxt to use the htmlconvert function from the html.xla add-in from within VBScript?
This is what I have so far:
set objApp = createObject("Excel.Application"
msgbox("instance of excel created"
//open the document
objApp.Workbooks.Open "\\g\ & dname
//install addin
objApp.AddIns("Internet Assistant Wizard".Installed = True
msgbox("instance of add-in created"
result = htmlconvert(objApp.ActiveWorkbook.ActiveSheet.usedrange, False, False,False, 1252, "\\g\intranet\assets\htmlpages\" + newFileName)
msgbox("convert finished"
Everything works up to the line that begins with "result=".
I have tried objApp.htmlconvert, but that doesn't work either.
Any ideas, references, resources, or war stories would be greatly appreciated.
Kathryn