Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Path
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Path
Try
Msgbox Environ("UserProfile") & "\help.xls" -- Jacob "Max2073" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File Path Too Long? Not Anymore! Check out Long Path Tool | Excel Discussion (Misc queries) | |||
http://CannotDeleteFile.net - Cannot Delete File? Try Long Path ToolFilename is too long? Computer Complaining Your Filename Is Too Long? TheLong Path Tool Can Help While most people can go about their businessblissfully unaware of the Windo | Excel Discussion (Misc queries) | |||
Creating Excel file that points to relative path .cub file | Excel Programming | |||
Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
How set file open path to filepath of file opened with Explorer ? | Excel Programming |