Open DialogBox in VBA

[schoujar]

Hi,

I know how to create an open dialog box in VB, but my work people only
have VBA (the 'lite' code editor in comparision to VS) installed. How
do I make an open dialog box in VBA considring it is so much more
restricted in its abilities compared to VB.

Any help would be great.

Cheers

Sahil

 

[Guest]

Application.Dialogs(xlDialogOpen).Show "C:\Windows"

 

[Leith Ross]

Hello schoujar,

There is an old Zen quote that answers your question very well...

"To find yourself, you must first lose yourself."

As a beginner you need to open your mind to new possiblities and not
summarily dismiss their potential through bias or prejudice based on
prior experience.

To put it simply, lose the attitude and be grateful for the help others
have to offer.

Sincerely,
Leith Ross

 

[schoujar]

I don't think I get what you are trying to say.

 

[Tom Ogilvy]

one thing he might of meant is us the GetOpenFileName

fName = Application.GetOpenFileName()

You don't need to make one. See Excel VBA help for arguments and details.

 

[schoujar]

Thanks for the help guys. It helped heaps.