Automatically opening file saved to someone "Documents&Sett' direc
 

Help Needed.
I had developed a macro that was used by myself, however now the macro needs
to be utilised by others.
The marco opens files, that have been exported from the corporate database.
The files are saved automatically to the users C Drive eg. C:\Documents and
Settings\"username €“ officer logged on"\help.xls
The only difference is the username in the file path.
Is there anyway that I can change the file path to automatically go to the
correct file, without having to create a different macro for each user.
Any help would be greatly appreciated.

Automatically opening file saved to someone "Documents&Sett' direc
 

This is the 3rd time this posting has appeared. See URL

http://tinyurl.com/yejpz7e


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160934

Microsoft Office Help

Automatically opening file saved to someone "Documents&Sett' direc
 

Try

Msgbox Environ("UserProfile") & "\help.xls"

--
Jacob


"Max2073" wrote:

Help Needed.
I had developed a macro that was used by myself, however now the macro needs
to be utilised by others.
The marco opens files, that have been exported from the corporate database.
The files are saved automatically to the users C Drive eg. C:\Documents and
Settings\"username €“ officer logged on"\help.xls
The only difference is the username in the file path.
Is there anyway that I can change the file path to automatically go to the
correct file, without having to create a different macro for each user.
Any help would be greatly appreciated.