Open file from certain path :{Solved}:

[daniels012]

We have 2 copies of a single file.
One is on :
Path2 = "C:\Documents and Settings\Primary User\Desktop\Toms Main\"
The other:
Path3 = "C:\Documents and Settings\MyDocuments\Daily\"

I need it to pick the proper path based on the computer it is on. Is this even possible?

If I need to give more details, let me know!

Michael

 

[Norie]

Michael

I don't understand what you mean.

What I'm trying to establish is whether or not the workbook with the code to open the other workbook is in the same directory as the workbook to be opened.

If it is then you might be able to use ThisWorkbook.Path to specify the path.

 

[daniels012]

Yes it is in the same directory

 

[daniels012]

Norie,
I am sorry, I used your code and it works.

I could not try it on both computers because one computer was down and I forgot to change "filename" to my actual files name.

The if statement was exactly what I needed.

Thank You,
Michael