ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Invalid Procedure call or Argument when Export to Excel via web pa (https://www.excelbanter.com/excel-programming/407884-invalid-procedure-call-argument-when-export-excel-via-web-pa.html)

Bruno

Invalid Procedure call or Argument when Export to Excel via web pa
 
Hi all,
I have a simple HTML table:

<table id="ResultTable"
<tr<tdTEST</td</tr
</table


Then I put a button to export to Excel
<INPUT TYPE="Button" value="Export2Excel" onclick="Export()"


The function:

<script language="vbscript"
Sub Export
Dim sHTML, oExcel, oBook

sHTML = document.all.item("ResultTable").outerhtml

Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add

oExcel.Visible = true
oExcel.UserControl = true

oBook.HTMLProject.HTMLProjectItems("Sheet1").Text = sHTML
oBook.HTMLProject.RefreshDocument

Set oBook = nothing
Set oExcel = nothing
End Sub

</script

This works OK in some computers but I get error "Invalid Procedure call or
Argument" on other computers.
It doesn´t work in several computers!!
The error points to
oBook.HTMLProject.HTMLProjectItems("Sheet1").Text = sHTML

How can I solve this?

All the computers don't have add-ons in C:\Program Files\Microsoft
Office\OFFICE11\XLSTART

It's Excel 2003 SP3

Thank you very much


All times are GMT +1. The time now is 08:37 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com