View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Wolverine Wolverine is offline
external usenet poster
 
Posts: 6
Default Avoid prompts with QueryTables

I am a VBA beginner and have managed to pull together an MS Access query
using the QueryTables feature. However, each time I run my code, I get a
dialog box asking me to select the database. I would like the code to
proceed without any user interaction once it's started. How do I prevent
this prompt from popping up?