File Path

M

Max2073

Help needed.

I developed a macro that only I used. However, the macro is now required to
be used by others.

The macro opens the required files from my C:\documents and
settings\max28052\ etc - the files are automatically named and saved to
officers c:\documents and settings\"username"\ after being exported from the
corporate database. The file names are always the same regardless of the
officer. The only differences in the file path eg. username.

Is there a way that I can change the marco to selected the required files
from the c:\documents and settings\"username of the logged on user"\help.xls
etc.

Any help would be greatly appreciated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top