Open Workbook from Same File Path with Partial Workbook Name

**brentjohn** · 06-11-2019, 09:33 AM

Greetings,
I know how to open a workbook from the same file path with the workbook's full name. However, because the workbook's name will change each month (certain dates will be added to the end of the workbook's name), I am needing to open a workbook from the same file path with a partial name. I have been working on the following code for the past few hours with no success.

Please Login or Register  to view this content.

**Norie** · 06-11-2019, 09:40 AM

What is the partial name?

Is it the only other workbook in the folder?

Can it be identified in any other way apart from the name, e.g. date/time created?

To look for file(s) by name you should probably try using Dir or File System Object.

**brentjohn** · 06-11-2019, 09:44 AM

Norie,
The partial name is "Garcia". There are several other workbooks in the folder. The partial name is the only way it can be identified, dates are added to the end of the name. Ex: "Garcia_6-11-19".

**Norie** · 06-11-2019, 09:45 AM

Is it the only file with 'Garcia' in the name?

**brentjohn** · 06-11-2019, 09:54 AM

Yes it is.

**KOKOSEK** · 06-11-2019, 10:00 AM

Try:

Please Login or Register  to view this content.

**brentjohn** · 06-11-2019, 10:35 AM

Kokosek,
Thank you for your reply. I tried your code and nothing happens.

**KOKOSEK** · 06-11-2019, 10:45 AM

Check files extension: *.xlsm maybe your files have different.
Works for me.

**brentjohn** · 06-11-2019, 10:54 AM

I verified the extension is correct and still nothing. Doesn't make sense if it works for you and not for me.

**Norie** · 06-11-2019, 11:10 AM

Try this.

Please Login or Register  to view this content.

**brentjohn** · 06-11-2019, 11:18 AM

Norie,
I added a ")" to the end of "strFileName". When i run the macro, I get a run-time error '13': Type mismatch.

**Norie** · 06-11-2019, 11:30 AM

Sorry, a bunch of typos in what I posted - try this.

Please Login or Register  to view this content.

**brentjohn** · 06-11-2019, 11:36 AM

Norie,
Works perfectly!!! Thank you much!!
Kokoser,
Thank you as well.

**brentjohn** · 06-15-2019, 07:59 AM

Norie,
I am hoping you can help me solve this issue.
Using your code works great (and I am very appreciative) if the workbook I want to open wbGarcia was "saved" to the folder. However, if I "move" the wbGarcia to the folder, it is not recognized.

**Norie** · 06-16-2019, 10:31 AM

It shouldn't matter how the workbook ended up in the folder.

What's happening with the code when it's been 'moved'?

**brentjohn** · 06-18-2019, 01:58 PM

Norie,
I apologize for the late response, I have been traveling the last few days.
It is working good now. Again, thank you much!!

Open Workbook from Same File Path with Partial Workbook Name

LinkBack

Thread Tools

Rate This Thread

Display

Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Re: Open Workbook from Same File Path with Partial Workbook Name

Thread Information

Users Browsing this Thread

Similar Threads

How to make commandbutton to open another workbook "with file path change"

[SOLVED] Using Workbook.Open to open an excel file with a variable path

VBA to open a workbook with partial Name

Macro to save workbook by referencing cell in another workbook for file name and file path

Macro to open a workbook from an unknown file path

How to open a workbook with partial Name?

Get path of open workbook

Bookmarks

Bookmarks

Posting Permissions