| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generic file path Excel Macro Question | Excel Discussion (Misc queries) | |||
| Variabilize File Path or File Name in SumProduct (and Vlookup too) | Excel Worksheet Functions | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| Macro help: File path in Excel 2000 | Excel Discussion (Misc queries) | |||
| Macro - Feeding path and file name to PDF maker | Excel Discussion (Misc queries) | |||
Threaded Mode
