VB conflict with WIndows XP and Windows '07

[HotNumbers]

Can someone please help me modify the following code. I have two group of users some are on XP and some are on WINDOWS 07. Those that are on XP the following VB code works as written. However; the group that is now on WINDOWS 07 they are receiving the following error.

WINDOWS 07 ERROR MSG:

Run-time Error '75:
Path/File access error.

'Open a new .txt file for output
NewFileName = "C:\" + NewSheetName + ".txt"

 

[b17g]

Windows Server 2007?

 

[HotNumbers]

no...

This is on local machines.

 

[phagan]

This probably has to do with windows 7 built in protection. It will not allow you to write to the c: drive directly. You should never do that anyway as it is bad practice. I would suggest writing to the desktop.

sUserProfile = Environ("USERPROFILE") & "\Desktop\"

should work for both OSs

 

[HotNumbers]

EXCELLENT... This worked.

 

[phagan]

Glad I could help.