Opening other fiels in same folder

[KevinThomas]

Hello, I have a master sheet (Called daily report) which has a macro to call other excel sheets to open within the same folder.

The folder is on a shared directory (P for me) and the problem i have is that the letter of the directory is different on other people's computers.

Is there a better way of coding the below so the macro will work without having to state the folder directory letter?

By the way, this is just the beginning of the macro - the remainder is irrevlevant to my request.

Please Login or Register  to view this content.

[davegugg]

There are a couple of things I can think of. The easiest and most reliable would be to use an .inputbox to have a user type in the drive letter or an application.getopenfilename to select the first file, then get the drive and folder name from that.

If that is not an option, the below code will go through each drive A:\ to Z:\ and search for the first file you list in your code above. Once found, it will make the variable strFound equal to that DRIVE (ex: P:\)

Please Login or Register  to view this content.

After putting this code first, you'd have to alter the rest of your code to use strFound:

Please Login or Register  to view this content.