| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Generic file path using vba
I have a vba code that opens a file placed on my desktop, but this vba code
must be used in several pc's, and in every pc the desktop path is different due to different user names. I would like to now if it's possible to write a "generic" path for the vba to find the files with no matter which of the pc desktops the macro is being ran at. The files will be placed always in the desktop folder. here is the string I am using to open the file. Workbooks.Open "C:\Documents and Settings\[Username]\Desktop\Data_Export.xls" Any advice would be appreciated |
| 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) | |||
| Generic file path Excel Macro Question | Excel Discussion (Misc queries) | |||
| Formula too long - new file path is shorter than old file path - Excel 2003 | Excel Worksheet Functions | |||
| check if file with generic name already open | Excel Programming | |||
Threaded Mode
