View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Flanagan Bob Flanagan is offline
external usenet poster
 
Posts: 340
Default Can't create ini file on a Vista machine

I tried the following in both Excel 2003 and 2007 on a Vista machine:

Sub Test()
Dim I As Integer
I = FreeFile
fName = "C:\aaa.ini"
Open fName For Output As #1
Print #1, "Test"
Close #1
End Sub

I get a Path/Fle access error on the Open line. The above works perfect in
other versions of Excel. I tried different folders and still no joy.

When I tried manually saving a workbook to the programs file directory where
the add-in was located, to the root C drive and to the windows temp
directory. , I get a "you don't have permissions" error message each time.
Most likely this is what is triggering the path/file error. I guess I could
save to the my documents directory, but the file is not one the user needs
to see. And if they see it, they are likely to delete

Any ideas on how to solve?

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel