View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nelson Nelson is offline
external usenet poster
 
Posts: 69
Default One connection multiple unique SQL's

Good day, in creating a my worksheets that have differing DB queries I
noticed that I have also created a different connection string each time.

Now when I update my 10 work sheets I am prompted for my password and DB
details 10 times

All connections are to the same DB only the queries are different, how can I
make it so that I am only asked once for the DB information then all the
sheets get updated?

Thanks
--
Nelson
--
Nelson