Unanswered: SaveAs method of Workbook class failed
Stupid job, actually. Every day I have to connect to certain server, get an XLS file, open it, save as HTML and upload to web server. Source filename is always the same. To cut it short, the VBS I am working on simply doesn't do it - it returns the "SaveAs method of Workbook class failed" error. And I am really lost here!
I know it's not ASP code, but it's very similar.
Here's the script:
pathstring = filesys.GetAbsolutePathName(".")
pathstring=pathstring & "\"
file = InputBox("Filename,without the extension","Enter")
Okie, I haven't tried this before but a couple of thoughts that might help.....
Does the htm file already exist?? Are you attempting to write over an existing file.
I have been looking at some examples online and the method call seems slightly different... particularly the specification of the file format... they tend to use something like Excel.XlFileFormat.xlHtml