Creating an Import Dialogue for files into Excel 1

[abitslow]

I am looking to make a macro to allow users of my spreadsheet to automate the import of a file which they create. Is it possible to make a dialog box so that they browse-to and select a file and then I can use this selection in a QueryTables.Add context to import it? Alternative suggestions welcome.

Thanks in advance,
Matt.

 

[PHV]

Have a look at the Application.GetOpenFilename method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

Of check out...
[tt]
Data > Get External Data > IMPORT
[/tt]

Skip,
[sub]
[red][/red]
[/sub]

 

[abitslow]

Thanks PHV. With a bit of searching on how to use the function it looks like being the solution I was looking for.

http://msdn2.microsoft.com/en-us/library/aa195744(office.11).aspx