Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I've made a spreadsheet in Excel 2002 (on an XP machine) that uses 2 Queries to retrieve data. I'm setting the querytable.commandtext in VBA, so I can update the query based on a date entered by the end user in an inputbox. When I try to run it on a 98 PC using Excel97, I have a missing reference to query 1.0 Type Library. Can anyone tell me what file(s) I am missing? And how to install it/them? (I've installed Microsoft Query from the Office 97 CD, so I'm baffled.) Thanks in advance SW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
Problem with .Background Query option of ODBC Query | Excel Programming |