| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need VBA assistance for Excel Open Dialogue Box
Good morning.
I need to figure out code that will simply change current directory to a set directory and then show Excel's "Open" Diaglogue box. I am aware that I can use an open command to open a certain file, but I don't want to do that, just Excel's Open dialogue box. Any suggestions? Thanks Cordially, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need VBA assistance for Excel Open Dialogue Box
sPath = "C:\MyFolder"
chdrive sPath chdir sPath application.Dialogs(xlDialogOpen).Show also look in excel vba help at Application.GetOpenfileName -- Regards, Tom Ogilvy "Brent E" wrote in message ... Good morning. I need to figure out code that will simply change current directory to a set directory and then show Excel's "Open" Diaglogue box. I am aware that I can use an open command to open a certain file, but I don't want to do that, just Excel's Open dialogue box. Any suggestions? Thanks Cordially, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need VBA assistance for Excel Open Dialogue Box
Really cool. Thanks Tom.
"Tom Ogilvy" wrote: sPath = "C:\MyFolder" chdrive sPath chdir sPath application.Dialogs(xlDialogOpen).Show also look in excel vba help at Application.GetOpenfileName -- Regards, Tom Ogilvy "Brent E" wrote in message ... Good morning. I need to figure out code that will simply change current directory to a set directory and then show Excel's "Open" Diaglogue box. I am aware that I can use an open command to open a certain file, but I don't want to do that, just Excel's Open dialogue box. Any suggestions? Thanks Cordially, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Preview in Open Dialogue | Excel Discussion (Misc queries) | |||
| When i open excel on the start dialogue, it does not open. | Setting up and Configuration of Excel | |||
| Excel VERY slow to move between folders in OPEN dialogue box | Excel Discussion (Misc queries) | |||
| In Excel, a dialogue box comes up and says "unable to open file". | Excel Discussion (Misc queries) | |||
| Need VBA assistance for Excel Open Dialogue box | Excel Discussion (Misc queries) | |||
Hybrid Mode
