alpercalik
New Member
- Joined
- Sep 12, 2007
- Messages
- 31
Hello,
My issue was running a web query with a dynamic URL. The URL has 3 variables which can be entered in A1,A2,A3 cells. I created an IQY file with notepad and placed it in Queries folder:
When i run Import Data from Data menu in Excel it asks me those 3 variables to be entered or selected from cells. So it downloads the data into my Excel sheet. I also set the parameters for those variables to be taken from the related cells. So it runs fastly and smotthly and the only thing i need to do is Refreshing the query.
But i realized that it doesn't download and paste all of the data i need from that source.
Is it "Data Range Properties" making it or something else i missed? I will be very happy if you can help me on this issue.
Thanks in advance.
My issue was running a web query with a dynamic URL. The URL has 3 variables which can be entered in A1,A2,A3 cells. I created an IQY file with notepad and placed it in Queries folder:
Code:
WEB
1
http://edb.volvo.net/cgi-bin/wis2/vehspec5.cgi?func=1&svariants=&pkl=04&f1=["f1","Select The Country"]&f2=["f2","Select the Year"]&f3=["f3","Select FO"]
Selection=2
Formatting=All
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
When i run Import Data from Data menu in Excel it asks me those 3 variables to be entered or selected from cells. So it downloads the data into my Excel sheet. I also set the parameters for those variables to be taken from the related cells. So it runs fastly and smotthly and the only thing i need to do is Refreshing the query.
But i realized that it doesn't download and paste all of the data i need from that source.
Is it "Data Range Properties" making it or something else i missed? I will be very happy if you can help me on this issue.
Thanks in advance.