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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Centrally documenting excel connection strings from multiple workbooks
Hi Skip, thanks so much for a really quick response - it got me 90% of the way! For those that have an interest - the final code set is here: Sub Test_Trawler() On Error GoTo err_TT ' ' Test_Trawler Macro ' Dim strFolder As String Dim strFile As String Dim strTemp As String Dim strTest As...- chris_who
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Centrally documenting excel connection strings from multiple workbooks
Hi all, VBA noob here - I've been given the task of documenting all of the excel connection strings used by a large variety of workbooks in a folder structure... what I need is a tool that sniffs out connection strings and documents the file name, location and connection string info...- chris_who
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
