Thread: MS Query
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ulincy[_2_] Tom Ulincy[_2_] is offline
external usenet poster
 
Posts: 4
Default MS Query

I recorded a procedure that includes a query (MS Query,
Excel 2002) to an external data source. The result set is
returned to a sheet in the workbook. How do you change,
or better yet, programmatically specify, the destination
path for the result set? Right now, if I move the
workbook to another folder, the query fails.

Thanks for your help.
Tom