View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pspyve[_3_] pspyve[_3_] is offline
external usenet poster
 
Posts: 1
Default Create ODBC link Using VBA


Hi All,
I do a lot of linking access db to excel. I do it via the ODBC link on
the computer(ODBC Data Source Administrator). I have to manually set
this up for each user.
Just wondering if you can, or if it is possible to create that link
programmaticly using VBA or maybe a batch file or something??

Thanks in advance.

Phil


--
pspyve
------------------------------------------------------------------------
pspyve's Profile: http://www.excelforum.com/member.php...o&userid=30656
View this thread: http://www.excelforum.com/showthread...hreadid=561885