View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nathan Gutman Nathan Gutman is offline
external usenet poster
 
Posts: 31
Default Can I edit .iqy file from code?

Is there a way to edit an .iqy file from code before running the
actual Web Query?
For example when downloading stock prices which require a list of
stock symbols how could I edit the iqy file from an Excel macro before
actually using it.
I know that I can edit it manually using Notepad.

Thanks,
Nathan
One step forward and two steps backwards.