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: 117
Default Problems saving XML file: Run-time error

I am using the MSXML library from VBA code in Excel 2007 on Windows
Vista. Everything works fine until I try to save an XML file with
this code:

Const MyLocation = "C:\Users\Alan\Desktop"
. . .
Set objDom = New DOMDocument
. . .
objDom.Save (MyLocation)

At that last line, I get the following error:

Run-time error '-2147024891 (80070005)':
Access is denied

Why would it not let me save a file?

Thanks, Alan

 
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
Excel 2007 - error saving file & error loading dll TinaF Excel Discussion (Misc queries) 0 July 1st 09 01:49 PM
Problems with saving a Excel file Just Me[_2_] Excel Discussion (Misc queries) 2 November 4th 07 01:54 AM
Saving a file with time and date at a set time period Mark Dullingham Excel Programming 10 March 3rd 07 12:10 PM
Excel 2003: Alignment problems saving workbook as prn file. [email protected] Excel Programming 3 January 13th 05 06:47 PM
Problems with saving cell values to file Mika[_2_] Excel Programming 2 December 24th 04 11:44 PM


All times are GMT +1. The time now is 12:27 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"