Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path and File
Help needed.
I had developed a macro that was only used by myself, however this macro will now also be used by others. In the macro I was using the full file path, however this is now causing some problems. Is there anyway that I can change the macro to open the required files based on the following path: - c:\documents and settings\"username - logged on officer"\help.xls The files that need to be opened are automatically named when exported from the corporate database - the files will be named the same for each officer - the only difference is the username. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path and File
Perhaps:
Sub officer() Dim s1 As String, s2 As String, s3 As String s1 = "C:\Documents and Settings\" s2 = Environ("Username") s3 = "\help.xls" Workbooks.Open Filename:=s1 & s2 & s3 End Sub -- Gary''s Student - gsnu200909 "Max2073" wrote: Help needed. I had developed a macro that was only used by myself, however this macro will now also be used by others. In the macro I was using the full file path, however this is now causing some problems. Is there anyway that I can change the macro to open the required files based on the following path: - c:\documents and settings\"username - logged on officer"\help.xls The files that need to be opened are automatically named when exported from the corporate database - the files will be named the same for each officer - the only difference is the username. |
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 |