View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default Importing Data via Web Query - Can values be passed to query?

Here is a quick solution with a CommandButton and some VBA code:
http://cjoint.com/?fjsociCanS

HTH
--
AP

"Mitch" a écrit dans le message de news:
...
Was going to ask the exact same question as you John. Would love to know
if
this is possible. Can't find the issue being discussed earlier.

/Mitch

" skrev:

Thank AP,

This enables me to build a link within a Spreadsheet; however, I'm
trying to use the dynamic link to load external data via the Data -
Import External Data - New Web Query utility. I could not dynamically
construct the URL.

-johng