| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically opening file saved to someone "Documents&Sett' direc
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 file, without having to create a different macro for each user. Any help would be greatly appreciated. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically opening file saved to someone "Documents&Sett' direc
This is the 3rd time this posting has appeared. See URL http://tinyurl.com/yejpz7e -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160934 Microsoft Office Help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically opening file saved to someone "Documents&Sett' direc
Try
Msgbox Environ("UserProfile") & "\help.xls" -- Jacob "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 file, without having to create a different macro for each user. Any help would be greatly appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "File Error: Data May Be Lost" when file saved on Mac is opened inWindows | Excel Discussion (Misc queries) | |||
| i "saved" instead of "saved as". I need old file back | Excel Discussion (Misc queries) | |||
| How do I Run Macro on Opening if user is not the "Last Saved By" U | Excel Programming | |||
| Stop "Book1" from opening from a saved file | Excel Discussion (Misc queries) | |||
| Opening web documents as "text" | Excel Programming | |||
Linear Mode
