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