I hate paths

[Ross]

I have prepared a spreadsheet that has a macro(recorded) in it that when
invoked, opens another excel file.
Here is that code:
Workbooks.Open Filename:= _
"C:\Documents and Settings\Ross D\My
Documents\AURORA\jimspreada1.xls"

I plan to distribute these sheets to various other employees at my agency
for their use. Both files will always be in the same directory -- however,
a different directory on each person's machine. How do I change the above
code to open that file in the current directoy, whatever that directory
might be?
Ross

 

[Ron de Bruin]

You can use Thisworkbook.Path Ross

 

[Bob Phillips]

Haven't we been here before?

Workbooks.Open Filename:= "jimspreada1.xls"

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

There should be a common description of the path that will be available to
all, eg. GA123gg6\apps

You should be able to see that in Windows Explorer or you may have to ask IT
for help. If you can establish that common path description, you will have
no problems.