GetWindowsDirectory in Vista

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Broadband Al - 20 Sep 2007 17:04 GMT

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?

Signature

Oxfordshire, UK

Reply to this Message

Tom Ogilvy - 20 Sep 2007 17:38 GMT

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.

Signature

Regards,
Tom Ogilvy

> 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?

Reply to this Message

Broadband Al - 21 Sep 2007 17:08 GMT

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.

Signature

Oxfordshire, UK

> Don't know what method you tried, but try:
>
[quoted text clipped - 9 lines]
> > Vista machine. It doesn't seem to find the Windows Directory. How do I find
> > it?

Reply to this Message