Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot access the htmlconvert function from html.xla

Status
Not open for further replies.

kathryn

Programmer
Apr 13, 2000
776
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top