Hello,

I'm trying to write code in excel that will do a couple of things related to opening a file.

When they have my template workbook open and they run my code

I want the code to:
1. Launch the open file dialog box (files of type: all files)
2. I want the open file dialog box to open to a destination/directory that I have already specified in my code
3. Allow them to specify the file (it never has an extension but it's technically a tsv)
4. I know it's going to be a tsv so I'd like it to fly through the text import wizard
5. Store the name of the new workbook in a variable

Can anyone help?

Thanks