Thomas Becker wrote:
Thank you for your link - I had given it a try but when I run it I
hit the refresh line and get a :Runtime error 1004: general odbc
error"
Any thoughts? - While debugging I've checked all of the variables
prior to that line and they are set exactly as I would expect. I
have Access2003 (with all updates) running on XPPro Sp2. Files are
on local drive. I test the code by simply moving the mdb to a new
directory and re-opening the spreadsheet.
Usually that means you have a syntax error in your connection string. Put a
Debug.Pring qt.Connection
line before the Refresh line and look at the string. It can be something
really small like a missing space or comma, so you really have to look
close. If you're sure you got it right, post the relevant portion of the
code and someone may be able to spot the problem.
--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com