Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by dskjkk
-
MS query on a password protected excel 2007 file
Thanks Skip... I was hoping that the ability to edit / disable the password in the Datasource connection could be done through the existing interface's check boxes. Guess I'll give the VBA approach a try. Thanks.- dskjkk
- Post #4
- Forum: Microsoft: Office
-
MS query on a password protected excel 2007 file
I am using excel 2007. I have an excel file that is the source for multiple Microsoft queries. This file is saved in .xlsx format. Using Excel's feature (Data>From Other Sources>From Microsoft Query) I set up a DataSource connection (i.e. the dsn file) pointing to this excel source and...- dskjkk
- Thread
- Replies: 3
- Forum: Microsoft: Office
