How to save a file in Vista's Windows Folder

[Guest]

I have Excel VB code that saves a tiny ini file in the Windows Directory.
Worked a treat on XP for years. It won't run on Vista because of the
security permissions for the Windows folder. I can work around it for new
files but all the hundreds of existing examples of my spreadsheet crash on
opening on a Vista machine. I don't want to reprogram every instance - all I
need is to save a tiny file in the Windows Directory! But how???

 

[Steve Riley [MSFT]]

The Windows folder is for operating system files, and nothing else. We have
tightened the security on that folder to reflect this fact. I would
encourage you to store the .ini files in a folder that you create. Then look
for a way to do some kind of (possibly programmatic) search-and-replace in
your spreadsheet to change the existing references to the new location.

 

[munchie]

I have Excel VB code that saves a tiny ini file in the Windows Directory.
Worked a treat on XP for years. It won't run on Vista because of the
security permissions for the Windows folder. I can work around it for new
files but all the hundreds of existing examples of my spreadsheet crash on
opening on a Vista machine. I don't want to reprogram every instance - all I
need is to save a tiny file in the Windows Directory! But how???

If you *really* want to place it in the Windows folder, run the
Command Prompt as administrator and copy it there. So far, I've had
nothing but success with this technique.

-- Munchie