Open File Dialog without Having it linked to a form

[simeybt]

Hi All,

I want my code to throw up a file dialog window so my user can select a file from which data is to be imported from, but I don’t want this linked to a form I just what it to pop up once program needs the file name. Is this possible or do I need t put the dialog onto a form.

Simon

 

[TonyJollans]

Hi simeybt,

Try using ..

myFileName = Application.GetOpenFileName

Enjoy,
Tony

 

[simeybt]

Works a treat tony,

Thanks for the quick response

Simon

 

[TonyJollans]

My pleasure.

Enjoy,
Tony