| Home > Forum Home > Automating Data Analysis Tasks > Excel web query results destination > Source for IQY query? | Share |
Source for IQY query?
Excel Help for Source For Iqy Query? in Automating Data Analysis Tasks
| Forum Topic | Login |
Source For Iqy Query? | Rate this: (3/5 from 1 vote) |
 | I figured out how to increment the destination by accident... so Im good there, now I have another issue. I want my web query IQY file to point to cell B1 on my spreadsheet to get its 'variable' example: The searched url is: http://www.myserver.com/search?stuff=["stuff"] "stuff" is the variable. Right now it prompts in a dialog box for me to enter that value. If I do enter the value it works fine. However, I want it to look in Cell B1 for that value and not prompt me. Anyone know how to do this in an IQY file? Or get the VB code to pass that variable to the IQY query so it doesnt prompt? | |
| Posted by jtzako on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Source for IQY query? in the Excel Business Solutions Directory |