hi, i followed the suggestion in the related post but when I changed my code from:
xlbook.WorkSheets(1).SaveAs(finalfilename)
to
xlbook.WorkSheets(1).SaveAs finalfilename, -4143
I get "Unknown runtime error".
Any idea what I'm doing wrong? the first line works, the second doesn't. (I am working asp, vbscript)
thank you.
VB ScriptMicrosoft Excel
Last Comment
Cory Vandenberg
8/22/2022 - Mon
cy_hung
why not use ?
xlbook.WorkSheets(1).SaveAs ( finalfilename, -4143 )
Cory Vandenberg
What version of Excel are you using? If it's 2003 or prior, then -4143 will save as a .xls file. If you are using 2007, then you should use one of the new enumerations. Check out this link for an list of the ones for 07.
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
xlbook.WorkSheets(1).SaveA