View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SPYREN SPYREN is offline
external usenet poster
 
Posts: 10
Default Modify Web Query using macros?

Greetings,

Is it possible to modify a Web Query command string by using a macro?
I need to execute one of 500 queries that are ALL similar with the exeption
of one number changing from the string (such as WebPage001List,
WebPage002List... WebPage500List.
Is there a way to access the query strings via Excel or VB?.

Thank you in advance for your support.