Can't create ini file on a Vista machine

[Bob Flanagan]

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

 

[Ron de Bruin]

Hi Bob

C:\ is protected in Vista

Create a folder for your add-in in a unprotected area on you hard disk

 

[Bob Flanagan]

Hi Ron. This thread appeared finally in my news reader. Sounds like it
will be better to create registry entries instead. At lieast that can be
done across platforms.

Bob

 

[Peter Grebenik]

I don't know whether its just a typo, but you should have:

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

Just a thought.

Peter

 

[Ron de Bruin]

Yes that is also a good option

In Vista if you copy a add-in in the Library folder and have a option in the add-in to change
things and save the changes in the Add-in then you also have a problem.

The Library folder is also protected

 

[Mark Jones]

Hi Bob

C:\ is protected in Vista

Create a folder for your add-in in a unprotected area on you hard disk

Is there a way to make these protected areas into
unprotected areas?

 

[Ron de Bruin]

Hi Mark

In the properties of a folder there is a security tab
You can chnage the security there
But not all Vista versions have that tab

Read this from help

***********
Why is the Security tab missing from my file and folder properties?

The Security tab is not available on file and folder properties in Windows Vista Home Premium,
Windows Vista Home Basic, and Windows Vista Starter.
The Security tab also is not available if you are using the FAT or FAT32 file system
*************

Use the users folder to avoid problems
"C:\Users\Ron\test\"

You can build the string with
Environ("UserName")