View Single Post
  #2   Report Post  
 
Posts: n/a
Default

hi,
i think it is:
Application.Dialogs(xlDialogOpen).Show

-----Original Message-----
Good morning.

I am using an Access VBA module to control Excel and I

need to figure out
code that can 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. I

want dialogue box and
not specify a file. Any suggestions? Thanks

Cordially,
.