Macro to find filepath and open file

**sds1126** · 07-14-2014, 09:08 AM

I'm working on making a macro that will allow users to input an invoice number in a cell (A1). The cell next to it (B1) contains a formula that returns the vendor that invoice came from.

With that, the purpose of the macro is to take the vendor name, use it as a string to locate the folder name, and then use the invoice number as a string to locate the specific file in the folder, and open it. The way our file system is set up is that we have an "invoice folder" which contains vendor folders. Each vendor folder contains invoices named by job date, vendor, and invoice number, so the file names look like this: 2014.04 - Vendor Name - 1234.pdf

Please Login or Register  to view this content.

My code isn't complete - I don't have the second half to locate the specific file written, but this should be enough for you to see the logic of what I've coded so far. Since I'm fairly new to VBA, it's cobbled together from different "how-to"s i've found online, so parts may be redundant.

From what I have so far, i expected that the macro, when run, would open up the vendor folder. It's not working so far.

Can anyone help me out?

**sds1126** · 07-15-2014, 09:44 AM

I've simplified my approach and my code, and have what I think should be a simple problem to solve, however I don't know enough about VBA syntax to figure out how to word the code I'm looking for.

Please Login or Register  to view this content.

What I have in Cell B7 is a partial file name. Each file in the directory that I'm searching is formatted the same, with an invoice number as the last part of the name.
What I have in Cell B4 is the file path of the folder containing the file referred to in B7.
What I'm trying to do is have excel open up the file based on the partial file name given in B7. I know that * can be used as a wildcard but I haven't figured out how to use it to return the file I'm looking for.

My question is, where in the code above should I place the * in order for the macro to open the first file in the folder (referred to in B4) using the last part of the file name (which is contained in B7)?

I hope my question is clear and if not, I can provide more detail or parts of the workbook.

Any help will be much appreciated.

**apo** · 07-15-2014, 10:32 AM

Hi..

Maybe something like:

Please Login or Register  to view this content.

**sds1126** · 07-15-2014, 10:55 AM

apo,

With a slight modification, that worked! I really appreciate the feedback, and will mark the thread as solved. Thank you very much.

Macro to find filepath and open file

LinkBack

Thread Tools

Rate This Thread

Display

Macro to find filepath and open file

Re: Macro to find filepath and open file

Re: Macro to find filepath and open file

Re: Macro to find filepath and open file

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA to Open Group of Workbooks Based on Name and Filepath

[SOLVED] Macro to select and open filepath stored at worksheet

[SOLVED] Trying to get the filepath on "Open", but get filepath of a temporary file instead

Macro to open word doc, then open another file in word and then excute a find replace

Bookmarks

Bookmarks

Posting Permissions