![]() |
Update Web Query Parameter with a Macro
Hi-
I am using the MSN Money macro and I currently have it get the range of symbols to lookup from a range of cells on a worksheet. My problem is that when I enter a new symbol at the bottom of the range I have to go in and manually update the query everytime to expand the selection box by one cell. I cannot simply select the whole column however as there text above and below that I do not want to import. Is there anyway to change the web query parameters via a macro? Thank you, -Dan |
All times are GMT +1. The time now is 08:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com