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