Opening a file with only a partial file name

[zinzah]

I am trying to open a file with only a partial file name being entered thru an input box

One user will create the file and save it. The file name is created by pulling data from 3 different worksheet cells - i.e. - number, location and name.

A second user will try to open that file by entering only the number portion of it.

There are no duplicate file names in the directory where the file is located, so when User2 enters the number, it will only find one file. I have done the reading on "File.Open", but do not want a dialog box to open. I would like this to happen automatically once User2 enters the number.

Is this possible?

Thanks in advance!

[antoka05]

You can try to use Dir instruction, for example:

Please Login or Register  to view this content.

where myPartialName is the number portion of the file.
That instruction will return the first file name in case it founds more than one file.

Regards,
Antonio

[zinzah]

Thanks! at least now the msgbox(just for testing) is returning the correct file name. I do get a "Run-time error '1004': application-defined or object-defined error. and I'm pretty sure my syntax on the OPEN line is correct? or am I going crazy?

Please Login or Register  to view this content.

[zinzah]

Ok, so now it seems to work, but it is opening a NEW workbook called file_to_open, not opening the one that it finds. why is it driving me crazy?

Please Login or Register  to view this content.

[FrankBoston]

The DIR function returns just the plain filename with no path information. So, you need to put the path back in when you open the workbook. I suggest:

Please Login or Register  to view this content.

[zinzah]

THANK YOU!!!!!!!!! You have no idea how crazy I have been going to get it right!!!! Thanks you again!!!

[skalumba]

Hello, first time ever posting on a forum.
Can this be used in an excel worksheet to link/open an external PDF where the first character of the PDF file name are stored in, say for example, cell A3, and the rest of the file name can vary?
=HYPERLINK("./test folder path/" & A3 & "*.pdf")

[skalumba]

I know this is pretty hokey, but I took a stab at it (3 columns back is a formula that pumps out the correct path)

Please Login or Register  to view this content.

[arlu1201]

skalumba,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.