I hate paths

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ross - 04 Apr 2007 22:06 GMT

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

Reply to this Message

Ron de Bruin - 04 Apr 2007 22:13 GMT

You can use Thisworkbook.Path Ross

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>I have prepared a spreadsheet that has a macro(recorded) in it that when
> invoked, opens another excel file.
[quoted text clipped - 9 lines]
> might be?
> Ross

Reply to this Message

Bob Phillips - 04 Apr 2007 22:17 GMT

Haven't we been here before?

Workbooks.Open Filename:= "jimspreada1.xls"

Signature

---
HTH

Bob

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

>I have prepared a spreadsheet that has a macro(recorded) in it that when
> invoked, opens another excel file.
[quoted text clipped - 10 lines]
> might be?
> Ross

Reply to this Message

Jim Jackson - 05 Apr 2007 13:34 GMT

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.

Signature

Best wishes,

Jim

> Haven't we been here before?
>
[quoted text clipped - 14 lines]
> > might be?
> > Ross

Reply to this Message