In Excel 2003 it seems that the location of saved €˜queries such as
XLQUERY.XLA has changed, from residing under the C:\Program Files\Microsoft
Office\Office10\Library\MSQuery\ folders to a new location in the user
profile folders. THis cause a problem for me because we use a lot of
spreadsheets with macros in which are shared by a number of different people.
THere are also issues with VBA Objects that have changed such as DClick.
Does anyone have a suggestions for solving these issues, or are there any
books available that go into this level of Excel use?