| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modify a data query ??
Thank you very much for your help.
CM. "Dick Kusleika" wrote: CM wrote: I'm able to create data queries that pull data from a Visual FoxPro table, but the query ends up with a fixed path to the data. Is there a way to parameterize the path so the user can provide it in a cell on the worksheet and the query references that cell for its path to the data? CM: No, you can't parameterize the path. You can change the path with VBA, though. See here http://www.dicks-clicks.com/excel/Ex...htm#ChangeConn You could put it in a Worksheet_Change event so that when the user changed the path in a certain cell, it would update the Connection and CommandText strings of your external data query. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help to modify the query? | Excel Worksheet Functions | |||
| Modify Recorded SQL Query to "Insert, Delete, Update" | Excel Programming | |||
| Stop to modify the SQL query manually entered into query ! | Excel Programming | |||
| Any Idea on how to modify this code relating to query??? | Excel Programming | |||
| Modify Web Query using macros? | Excel Programming | |||
Hybrid Mode
