Open workbook from file location

[erice]

Hello,

I am trying to come up with a way to open a file from a specific directory upon clicking a button. The workbooks that I am wanting to open will always be in the same folder, but new versions are updated daily so I want the user to be able to select the specific workbook they are wanting to open. For example, if the user wanted to open "systems check" from the Documents folder the code below works, but If they wanted to open a different file in that location I want the file explorer to open to that file location. Then the user would select the file they wanted.

Please Login or Register  to view this content.

Thank you!

[lexusap]

Hi Erice,

try this code, i have build something similar in the past. where it will open up dialog box, user to select a file and open.

Please Login or Register  to view this content.

Thanks
Lex

[erice]

Lex,

Thank you for that. It is working like I was hoping it would. Since we like to bury our files in complex file paths this will save a lot of time!

[Mohamed Hassan]

Thank you erice for this important topic
And Thank you Lex for this amazing code but I have a question here ... That how can I solve the debug when I press Cancel " I mean after the pop windows appear to select the needed file"

Thanks In advance.

[1aaaaaaaaaaaaaaa]

Please Login or Register  to view this content.

[Mohamed Hassan]

Thanks but after added the mentioned line still got the debug Capture18.PNG

[1aaaaaaaaaaaaaaa]

Hi, below is the code I usually use, may run better

Please Login or Register  to view this content.

[Mohamed Hassan]

Many Thanks Poizhan it's working great and please still need another thing that if there's any possibitlly to copy range of data from another closed workbook " without opening it "to another active workbook whatever the cells format, As I have code (GetData) but when I run it it's not get all data because of formatting .

Thanks in advance

[1aaaaaaaaaaaaaaa]

@Mohamed, You're welcome, I recommend opening another thread so we don't muddy the waters. Make sure to describe your issue in detail and provide a sample workbook.

[Mohamed Hassan]

Many Thanks Poizhan I'll do it dear

[daboho]

Many Thanks Poizhan it's working great and please still need another thing that if there's any possibitlly to copy range of data from another closed workbook " without opening it "to another active workbook whatever the cells format, As I have code (GetData) but when I run it it's not get all data because of formatting .

Thanks in advance

Maybe like this

Please Login or Register  to view this content.

[erice]

This was working for me, until I tried to move it over to look for files on a shared network drive. You can see that the folder I am trying to reference is located in \\corp.worthing.local.\Secure\WTN\Cost_Est\COST ESTIMATING\2018EST. Is there something else I need to do if I want to use this on a shared network drive?

Please Login or Register  to view this content.