LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SaveAs method error Horatio J. Bilge, Jr. Excel Discussion (Misc queries) 3 October 6th 09 09:05 PM
Error 0x800A03EC trying to set range value mdengler New Users to Excel 2 March 1st 06 01:22 PM
error message with saveas DJA Excel Discussion (Misc queries) 6 February 17th 05 06:03 PM
SaveAs Error Steven K Excel Programming 1 September 17th 04 05:41 PM
Chart.Export throws COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC. Steven Excel Programming 1 November 5th 03 06:59 PM


All times are GMT +1. The time now is 05:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"