VBA- Using %Userprofile% in Filepath

[willwill88]

I'm trying to call a .bat file which is located in My Documents. Is there a way of making VBA in Excel to understand %userprofile%, so that it can be launched from different windows accounts?

Example:

Call Shell("C:\Documents and Settings\william\My Documents\AutoFormat.bat", vbReadOnly)

Call Shell("C:\Documents and Settings\%userprofile%\My Documents\AutoFormat.bat", vbReadOnly)


Cheers!

 

[VoG]

Try

Call Shell("C:\Documents and Settings\" & Environ("username") & "\My Documents\AutoFormat.bat", vbReadOnly)

 

[willwill88]

Worked like a charm! Thank you!