| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dialogbox Creation | Excel Discussion (Misc queries) | |||
| DialogBox Layout | Excel Programming | |||
| OpenFile dialogbox | Excel Worksheet Functions | |||
| how to detect if user has a dialogbox open | Excel Programming | |||
| DialogBox | Excel Programming | |||
![schoujar[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
