VBA, Vista, Excel2007

I attended Anthony's VBA course yesterday.
He provided some code, similar to that below, to create a new spreadsheet at the end of a macro. His code wrote to c:\ and I noted that this is difficult in Vista. Anthony asked me to send details.

I wrote the code below to test this. I used a spreadsheet with just a few numbers in it and tried to create testoutput.xls.

Vista will not write to C:\testoutput.xls, but will write to
c:\TestDir\testoutput.xls. It works with both under XP


Sub saveme()

Dim mynewfilename As String
Dim strName As String

strName = "InputSheet"

mynewfilename = "c:\" & "testoutput.xls"
'mynewfilename = "c:\TestDir\" & "testoutput.xls"



Sheets(strName).Select
Sheets(strName).Copy
ActiveWorkbook.SaveAs Filename:=mynewfilename

ActiveWorkbook.Close

End Sub


In fact, a simpler test is to simply try a dos command. If I go to any directory in a Vista Ultimate machine and type something like COPY TEST.DAT C:\ ,it will return the message 'access denied' so its no surprise that I cannot go there via VBA.

Any comments gratefully received.

Roger