Paths

R

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 directoy on each person's machine. How do I change the above
code to open that file in the current directoy, what ever that directory
might be?
Ross
 
D

Dave Peterson

You had a pretty good reply at one of your earlier posts. Didn't it work?
 

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

current directory 1
how do i loop thru all the worksheets in 2 files one by one 0
If WB not there; give message: What am I doing wrong? 3
Similar Book to Book Code, one works other does not 11
More efficient way for macro to run on multipe files? 5
Error Opening Workbook 3
Problem with file path to sharepoint 0
Opening file by partial name in same folder as master file 5

Top