Dynamic Web query

**bmind** · 06-23-2009, 10:44 AM

Searched for a while now for a way to do a dynamic web query. Test file attached shows what I want to do.
A7 is the cell with web query with address taken from input in A5. Need to pick up only the table with game pitching log.
Parameters will change and so A5 text will change. Need to update game pitching log for the parameters entered (year may change, name of pitcher may change)
A macro would be better (I think) so I can place a button on this page to update data from web query everytime reference cell changes (A5 in the attached sheet example).
Recorded a macro when inserting a new web query and the code I get is:

Please Login or Register  to view this content.

If I use this then my question would be how to change this so address is variable and its input comes from A5 (in test file attached) and also to have this on a specific sheet (not on the active sheet). Help is appreciated.

**bmind** · 06-23-2009, 12:08 PM

Anyone? Did not realize the defficulty of this task...

**bmind** · 06-23-2009, 04:53 PM

I am still searching but have not found anything yet..
Anyone has any ideas?

**bmind** · 06-23-2009, 10:54 PM

Is there a way to set .Name (in the code shown) as a variable that takes value of a cell? Maybe this might do it?

**bmind** · 06-24-2009, 09:47 AM

Anyone? Still searching...

**bmind** · 06-24-2009, 02:23 PM

Thiis must be a difficult one...

**bmind** · 06-24-2009, 04:07 PM

Hi,
I was thinking of a possible solution. Using the following code:

Please Login or Register  to view this content.

So then the issue is to figure out how I can write:
strConnection = [text of a specific cell]. I do not know the syntax needed. Appreciate your help. I hope this would work if cell text string is changed...