ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Export to excel via webpage: "Invalid Procedure Call or Argument" (https://www.excelbanter.com/excel-programming/407951-export-excel-via-webpage-invalid-procedure-call-argument.html)

Bruno

Export to excel via webpage: "Invalid Procedure Call or Argument"
 
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 on other computers I get error "Invalid
Procedure call or Argument"
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 06:44 AM.

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