View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brent E Brent E is offline
external usenet poster
 
Posts: 74
Default 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,