Path and File

M

Max2073

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

Working with Excel 2003

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.
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Path and File 1
File Path 1
File Path 2
File Path 1
File Path 2
File Path - Macros 3
Automatically opening file saved to someone "Documents&Sett' direc 2
Opening Files 1

Top