GetWindowsDirectory in Vista

[Guest]

I've been successfully using a programmed spreadsheet that first writes to on
Windows XP that reads from the Windows Directory. I now need to use it on a
Vista machine. It doesn't seem to find the Windows Directory. How do I find
it?

 

[Guest]

Don't know what method you tried, but try:

? Environ("SystemRoot")
C:\WINDOWS


the above is demo't from the immediate window.

Not tested in Windows Vista.

 

[Guest]

Thanks - the code is much shorter your way and works in Vista although the
index references are different. I was able to trap the correct fields -
thanks.