View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
John Hudson[_2_] John Hudson[_2_] is offline
external usenet poster
 
Posts: 1
Default Excel add-in MS Query

Hello Sara, these issues are still not resolved, and continue to cause
problems for us.

"Sara Hopkins" wrote:

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?