File Path - Macro
 

Need some help.

I developed a macro that was only used by myself, however this macro is now
having to be used by others.

The macro opened files stored in my C:\documents and settings\max28052\ .
The required files are exported from the corporate database and are
automatically named - the files are always named the same regardless of the
officer exporting the data.

I would like to change my macro to up the required files regardless of the
officer.

The macro was written with the full file path eg. c:\documents and
settings\max28052\help.xls is there anyway, that I can change the macro to
open the required files - the only change would be the officer - I would like
the macro to open the required files that are saved to c:\documents and
settings\""username of the logged on officer""\help.xls

Any help would be greatly appreciated.

File Path - Macro
 

No need to multi post you have responses in programming

"Max2073" wrote:

Need some help.

I developed a macro that was only used by myself, however this macro is now
having to be used by others.

The macro opened files stored in my C:\documents and settings\max28052\ .
The required files are exported from the corporate database and are
automatically named - the files are always named the same regardless of the
officer exporting the data.

I would like to change my macro to up the required files regardless of the
officer.

The macro was written with the full file path eg. c:\documents and
settings\max28052\help.xls is there anyway, that I can change the macro to
open the required files - the only change would be the officer - I would like
the macro to open the required files that are saved to c:\documents and
settings\""username of the logged on officer""\help.xls

Any help would be greatly appreciated.