View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sara Hopkins Sara Hopkins is offline
external usenet poster
 
Posts: 11
Default Excel add-in MS Query

Hi John, did you resolve your DClick issue? I ask because I am getting the
same error when I run an workbook with queries that is loaded to Sharepoint
Team Services. The queries appear to work, but the error message will upset
my users.

"John Hudson" wrote:

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?