change directory not working right

[Crispie38]

Hi

The below code is not behaving. I want the getopenfile to open at the location of the saved workbook. I've tried things like CurDir, but nothing seems to work and keeps reverting back to my directory (I'm at work so I: drive). The workbook is to be copied into different folders which is why I don't want to just hard code it.
I've also searched the site for options and have used most of them! Any ideas?
Thanks
Andy

Please Login or Register  to view this content.

[antoka05]

Did you try to use an instruction to change current drive, for example:

Please Login or Register  to view this content.

before to use the instruction:

Please Login or Register  to view this content.

I hope it can help.

Regards,
Antonio

[Crispie38]

Hi Antonio

I'm not sure I follow.
I've tried hardcoding it chdir("g:\") but that did not work.

Thanks
Andy

[Greg M]

Hi Crispie,

Include the following statement before the ChDir statement in your code:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Best regards,

Greg M

[Crispie38]

Thanks Gregg

That works wonders. Just out of interest how come just having the full file path doesn't work??

Thanks again

[antoka05]

If your path is on another active drive you need to change active drive and then path will run good.

Regards,
Antonio

[Greg M]

Hi again Crispie,

Many thanks for the feedback. You're welcome - delighted to have helped.

Excel maintains an active path for each drive, but only one active drive. The GetOpenFilename command looks at whatever drive happens to be the active drive, and then at the active path on that drive. This is why you need to select the appropriate drive as well as the appropriate path.

All the best,

Greg M

[Crispie38]

Good to know!!

Thanks to both of you for your help! :o)