I am extremely new to VB so please bear with me. I am trying to write a macro for Excel that will query a website and then pull in some data. I have been able to get it to work via prompting the user for input. However, I would rather the user simply fill in some cells/fields in the worksheet and use that data for the query. Does anyone know how to specify a particular cell in VB? In particular doing a wbe query?
Here is what I have in the webquery that work with prompting:
The macro prompts me for data between the "[" and "]" symbols. If you have any questions let me know and I would be happy to clarify.
Thank you for your help.