Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Files - Marco
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 location and file, without having to create a different macro for each user. Any help would be greatly appreciated. Sue |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Files - Marco
Answered - Thank you
"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 location and file, without having to create a different macro for each user. Any help would be greatly appreciated. Sue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How: Marco on Pivot Table to save as file up to 300 files | Excel Programming | |||
Marco to process data in many files | Excel Programming | |||
Opening Quattro Pro for Windows files (*.WB1 Files) using Excel 20 | Excel Discussion (Misc queries) | |||
Stop marco allert and update link allert when opening spreadsheet | Excel Programming | |||
How can I view files chronologically when opening multiple files | Excel Discussion (Misc queries) |