File Path
Help needed.
I created a macro that was used only by myself, however this macro now needs to be used by others. The macro opens files saved in my c:\documents and settings\max28052\ etc. The required files have been exported from the corporate database, the files are automatically named and saved to the users c:\documents and settings\"username - of the logged on user"\. I would like to know if I can change my macro to open the required file regardless of the logged on user. eg Currently my macro has the full file path c:\documents and settings\max28052\help.xls is there any way it read c:\documents and settings\"username"\help.xls so that I do not have to recreate a macro for each individual officer. Any help would be greatly appreciated. |
File Path
If you mean the username as in the windows log in name then yes like this: Code: -------------------- c:\documents and settings\" & Environ("username") & "\help.xls" -------------------- you can use the application username but this can be chanegd by the user at will or may not even be in place so your code would fail. Max2073;579372 Wrote: Help needed. I created a macro that was used only by myself, however this macro now needs to be used by others. The macro opens files saved in my c:\documents and settings\max28052\ etc. The required files have been exported from the corporate database, the files are automatically named and saved to the users c:\documents and settings\"username - of the logged on user"\. I would like to know if I can change my macro to open the required file regardless of the logged on user. eg Currently my macro has the full file path c:\documents and settings\max28052\help.xls is there any way it read c:\documents and settings\"username"\help.xls so that I do not have to recreate a macro for each individual officer. Any help would be greatly appreciated. -- Simon Lloyd Regards, Simon Lloyd 'Microsoft Office Help' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: 1 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160189 Microsoft Office Help |
File Path
take a look here 'Daily Dose of Excel » Blog Archive » Get the Path to My Documents in VBA' (http://tinyurl.com/ydmslhs) and here 'Locating Home My Documents Folder - Excel Help & Excel Macro Help' (http://www.ozgrid.com/forum/showthread.php?t=65466) -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: 558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=160189 Microsoft Office Help |
All times are GMT +1. The time now is 09:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com