Hi friends,
I am trying to pull data from the following base url:
http://www.powerexindia.com/PXILReport/pag…Report_New.aspx
However, the underlying url in the script is like this:
http://www.powerexindia.com/PXILReport/Res…65be107f2705193
&ControlID=e2859e2be9fd&Culture=1033&UICulture=1033&ReportStack=1&OpType=ReportArea&Controller=ClientControllerctl00_ContentPlaceHolder4_ReportViewerData&PageNumber=1&ZoomMode=Percent&ZoomPct=100&ReloadDocMap=true&EnableFindNext=False&LinkTarget=_top
Here, the variable parameters are ReportID and ControlID
What I want is that I should be able to enter these two parameters in two different cells and then they should be automatically pulled in the above url as I change them and the query should pull the data into my worksheet.
How can this be made possible pls guide me I am new to VBA and macros with only basic understanding.