how do i open up a file knowing the first part of the filename in excel using vba

**BrianTFC** · 04-22-2019, 11:40 AM

Hi,

I'm trying to open a file in excel using VBA but all I want to use is the first 6 numbers like (70000 city, state. xlsm) but I can't figure out the wild cards. if someone could help me I would appreciate it.

Please Login or Register  to view this content.

Thanks,
Brian

**PCI** · 04-22-2019, 02:14 PM

See how next code can help, customize Constantes to your need

Please Login or Register  to view this content.

**BrianTFC** · 04-22-2019, 02:29 PM

PCI,

Thank you for you help I think I might explained it wrong the only thing that is constant is the number length which is 6 numbers, the 6 numbers change along with city and state. I have people that use this excel program to open files but they only know the job number which is the 6 numbers., so I'm trying to get it to where all they have to do is put in just the 6 numbers and not have to worry about the city and state.

Thanks,
Brian.

**alansidman** · 04-22-2019, 02:49 PM

Maybe this:

Please Login or Register  to view this content.

**BrianTFC** · 04-22-2019, 02:56 PM

PCI,

that didn't work it keeps giving me an error

Please Login or Register  to view this content.

.

thanks
Brian

**alansidman** · 04-22-2019, 02:57 PM

amended code. See post 4 again.

**BrianTFC** · 04-22-2019, 03:00 PM

awesome!!!! It worked great!! Thank you!!!

**PCI** · 04-22-2019, 03:11 PM

In post 4, I would suggest to remove

Please Login or Register  to view this content.

**alansidman** · 04-22-2019, 03:31 PM

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

how do i open up a file knowing the first part of the filename in excel using vba

LinkBack

Thread Tools

Rate This Thread

Display

how do i open up a file knowing the first part of the filename in excel using vba

Re: how do i open up a file knowing the first part of the filename in excel using vba

Re: how do i open up a file knowing the first part of the filename in excel using vba

Re: how do i open up a file knowing the first part of the filename in excel using vba

Re: how do i open up a file knowing the first part of the filename in excel using vba

Re: how do i open up a file knowing the first part of the filename in excel using vba

Re: how do i open up a file knowing the first part of the filename in excel using vba

Re: how do i open up a file knowing the first part of the filename in excel using vba

Re: how do i open up a file knowing the first part of the filename in excel using vba

Thread Information

Users Browsing this Thread

Similar Threads

Help me - Excel cannot open the file '(filename)'.xlsx'

VBA Opening a file when only part of filename is known

Open word file with partial filename from excel

Excel connot open file (filename) xlsx

Open File in Directory with a Part of Filename as String

[SOLVED] Open excel file by providing a part of file name through inputbox

Excel cannot open the file '(filename)'.xlsx' because the file format or file extension is

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions