ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SaveAs causes 0x800A03EC error (https://www.excelbanter.com/excel-programming/330105-saveas-causes-0x800a03ec-error.html)

Justin Young

SaveAs causes 0x800A03EC error
 
Error Type:
Microsoft Office Excel (0x800A03EC)
Microsoft Office Excel cannot access the file 'C:\inetpub\wwwroot\reports'.
There are several possible reasons: €¢ The file name or path does not exist. €¢
The file is being used by another program. €¢ The workbook you are trying to
save has the same name as a currently open workbook.

and here's the code:
path = server.mappath("reports")
....
oBook.SaveAs(path & "\report.xls")

Really, that's about all there is to it. I'm just testing some stuff out
right now, but nothing will save. The path is fine, the directory is
completely empty, and there are no other workbooks open at all. I've also
tried using oBook.SaveAs("C:\report.xls") and that returns the same error but
for "C:\". If you just use "report.xls" it works fine and saves it to c:\my
documents. I've googled this like crazy, but came up with nothing.


All times are GMT +1. The time now is 10:48 AM.

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