VB in MS Excel - Filebrowse option

[DannyAuber]

I'm writing some VB in Excel
I want to prompt the user for a filename, so I want an Inputbox with a "Browse" option where they can browse to a file, and then hit OK - the inputbox will then return the path and file

No idea how to do it - doesn't seem to be a feature of inputbox.

Can someone help ?

thanks in advance

dan

 

[CajunCenturion]

Have you tried the GetOpenFileName API?

The GetOpenFileName creates a common dialog box for a user to pick a drive, directory, and filename. Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Loomah]

Hi
I don't usually post here but if you're coding in Excel then the vba command exists to do what you want ie

Application.Dialogs(xlDialogOpen).Show "C:\My Documents\Wherever\Excel"

The path shown is a filter basically identifying the first folder you see. using "*.*" will default to all files in the current directory.

;-) If a man says something and there are no women there to hear him, is he still wrong?

 

[DannyAuber]

Thanks Guys

works fine...