Open a file with varying filename

[gototcm]

I'd like to open a file from within VBA whose name will change based on user input (Inputbox). The following VBA code opens a specific file
(filename1):

#Set WBInput = Workbooks.Open("C:\users\myname\documents\folder\filename1")#

But how can the name "filename1" be written to be a variable name? Seems like concatenation of some kind should work but after multiple attempts I can't figure it out.

Thanks in advance.

[Naveed Raza]

try this

Please Login or Register  to view this content.

[MarvinP]

Hi gotocm,

Instead of trying to predict what file is to be opened in the VBA I do this command.

Please Login or Register  to view this content.

Which brings up a dialog box and the user can click on the file they want.

See if it can work for you...

[gototcm]

Thanks Marvin. This definitely works but I was trying to avoid having to search through a list of files for the correct file. I wanted to have that done automatically. But you have taught me yet another new trick. VBA has a seemingly endless number of objects and at times extremely frustrating to figure them out.