Open DialogBox in VBA
 

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


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=482070

Open DialogBox in VBA
 

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

Jim Thomlinson


"schoujar" wrote:


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


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=482070

Open DialogBox in VBA
 

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=482070

Open DialogBox in VBA
 

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


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=482070

Open DialogBox in VBA
 

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.

--
Regards,
Tom Ogilvy

"schoujar" wrote in
message ...

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


--
schoujar
------------------------------------------------------------------------
schoujar's Profile:
http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=482070

Open DialogBox in VBA
 

Thanks for the help guys. It helped heaps.


--
schoujar
------------------------------------------------------------------------
schoujar's Profile: http://www.excelforum.com/member.php...o&userid=26574
View this thread: http://www.excelforum.com/showthread...hreadid=482070