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

When I save an Excel document using saveas, I need to do something like this

myWB.SaveAs filename:="C:\abc23.xls" fileformat:=56

I'm not seeing a file name, or a fileformat in your saveas line.

This page from Ron de Bruin should help

http://www.rondebruin.nl/saveas.htm


--
HTH,

Barb Reinhardt



"Alan" wrote:

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

.

Barb,

Thanks, but I am saving an XML file using MSXML in Excel. I am not
saving an Excel file.

Alan