-
Hi Sam, Yes, that sounds like a lot of effort. Lifting a finger and all... You could code something that retrieves data from the other workbook without using the query editor. Basically an Open-Copy-Paste-Close action would do the trick. A userform could be used to create some flexibility for parameter...
-
Hi Sam, You could store the query (.dqy file) and use the following: Sub StartQry() Call Shell("Drive:\PathTo\msqry32.exe Drive:\PathToQry\YourQuery.dqy", 1) End Sub Haven't tested it under Windows Vista though. Rembo
-
Hi Jim Where and what are the parameters? (Worksheet, hard coded). MSQuery is notoriously flaky on high end parameters, but if it is just >[Date] or somthing then it should be fine. What has chnaged since you were last able to do it? Excel version, DB2 version. Using ODBC is a low-level data transfer...