Thread: Enumerate DSNs
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
urkec urkec is offline
external usenet poster
 
Posts: 131
Default Enumerate DSNs

"XP" wrote:

Using Windows XP and Office 2003;

If you have example code on how to loop thru or enumerate the DSN's on your
local machine could you please post it?

Thanks much in advance.


You can find a VBScript sample he

http://www.microsoft.com/technet/scr...5/hey0725.mspx

You can run it from VBA, you only need to replace WScript.Echo with
Debug.Print.

Hope this helps.

--
urkec