Home |
Search |
Today's Posts |
#1
|
|||
|
|||
web query
Hi
I want to use the web query What's the problem? The data are obtained in column A I want to retrieve data every day & I want to creates a situation where today's data override the immigrants of yesterday's data Does anyone know how to create a situation where the data of today will be on column A , the data of tommorow will be on column B etc. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
web query
Hard to tell without a file to test but you can have each webfetch
goto the next column or do your fetch in one sheet and have your macro copy to the next available column in the other sheet. Send me a file if desired. On Feb 15, 1:46*pm, eran3185 wrote: Hi I want to use the web query What's the problem? The data are obtained in column A I want to retrieve data every day & I want to creates a situation where today's data override the immigrants of yesterday's data Does anyone know how to create a situation where the data of today will be on column A *, the data of tommorow will be on column B *etc. -- eran3185 |
#3
|
|||
|
|||
Hi
you can see in this file that the macro - "loopThrough" has a line : Destination:=Range("A5")). i need a loop that will put this url's in this way : today - a5 tommorow - b5 ets ... thanks Quote:
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
web query
This can be done but I don't understand your requirement since the
urls provided do not agree with this ..Name = "bags_and_purses?ref=fp_ln_bags_and_purses" For the provided urls there is today and tomorrow but you don't say what info you want from the result.??? Contact me privately at dguillett1 @gmail.com ========== On Feb 15, 11:35*pm, eran3185 wrote: Hi you can see in this file that the macro - "loopThrough" has a line : Destination:=Range("A5")). i need a loop that will put this url's in this way : today - a5 tommorow - b5 ets ... thanks 'Don Guillett[_2_ Wrote: ;1399498']Hard to tell without a file to test but you can have each webfetch goto the next column or do your fetch in one sheet and have your macro copy to the next available column in the other sheet. Send me a file if desired. On Feb 15, 1:46*pm, eran3185 wrote:- Hi I want to use the web query What's the problem? The data are obtained in column A I want to retrieve data every day & I want to creates a situation where today's data override the immigrants of yesterday's data Does anyone know how to create a situation where the data of today will be on column A *, the data of tommorow will be on column B *etc. -- eran3185- +-------------------------------------------------------------------+ |Filename: yahoo macro.zip * * * * * * * * * * * * * * * * * * * * *| |Download:http://www.excelbanter.com/attachment.php?attachmentid=296| +-------------------------------------------------------------------+ -- eran3185 |
#5
|
|||
|
|||
thanks
i sent u an email eran Quote:
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
web query
On Feb 17, 12:58*am, eran3185
wrote: thanks i sent u an email eran 'Don Guillett[_2_ Wrote: ;1403701']This can be done but I don't understand your requirement since the urls provided do not agree with this ..Name = "bags_and_purses?ref=fp_ln_bags_and_purses" For the provided urls there is today and tomorrow but you don't say what info you want from the result.??? Contact me privately at dguillett1 @gmail.com ========== On Feb 15, 11:35*pm, eran3185 wrote:- Hi you can see in this file that the macro - "loopThrough" has a line : Destination:=Range("A5")). i need a loop that will put this url's in this way : today - a5 tommorow - b5 ets ... thanks 'Don Guillett[_2_ Wrote: - ;1399498']Hard to tell without a file to test but you can have each webfetch goto the next column or do your fetch in one sheet and have your macro copy to the next available column in the other sheet. Send me a file if desired.- - On Feb 15, 1:46*pm, eran3185 wrote:-- Hi I want to use the web query What's the problem? The data are obtained in column A I want to retrieve data every day & I want to creates a situation- where- today's data override the immigrants of yesterday's data Does anyone know how to create a situation where the data of today- will- be on column A *, the data of tommorow will be on column B *etc.-- -- -- eran3185--- +-------------------------------------------------------------------+ |Filename: yahoo macro.zip * * * * * * * * * * * * * * * * * * * * *| |Download:http://www.excelbanter.com/attachment.php?attachmentid=296| +-------------------------------------------------------------------+ -- eran3185- +-------------------------------------------------------------------+ +-------------------------------------------------------------------+ -- eran3185 You neglected to respond to my questions, sending a file with NO explanation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert hard coded query criteria to Parameter Query | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Save data retreived from query without saving query | Excel Discussion (Misc queries) | |||
Edit Query from Excel will not open query in MSQuery | Excel Programming | |||
Problem with .Background Query option of ODBC Query | Excel Programming |