View Single Post
  #1   Report Post  
Brent E
 
Posts: n/a
Default Need VBA code for "Open Dialogue" box

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,