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,
|