web query

E

eran3185

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 wher
today's data override the immigrants of yesterday's data
Does anyone know how to create a situation where the data of today wil
be on column A , the data of tommorow will be on column B etc
 
D

Don Guillett

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.
 
E

eran3185

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_ said:
;1399498']Hard to tell without a file to test but you can have eac
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.


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 situatio where
today's data override the immigrants of yesterday's data
Does anyone know how to create a situation where the data of toda will
be on column A *, the data of tommorow will be on column B *etc.

+-------------------------------------------------------------------
|Filename: yahoo macro.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=296
+-------------------------------------------------------------------
 
D

Don Guillett

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
==========

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.

+-------------------------------------------------------------------+
|Filename: yahoo macro.zip                                          |
|Download:http://www.excelbanter.com/attachment.php?attachmentid=296|
+-------------------------------------------------------------------+
 
E

eran3185

thanks
i sent u an email

eran


'Don Guillett[_2_ said:
;1403701']This can be done but I don't understand your requirement sinc
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
==========

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 you macro
copy to the next available column in the other sheet. Send me file
if desired.- -
On Feb 15, 1:46*pm, eran3185 <[email protected] 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 situation-
where-
today's data override the immigrants of yesterday's data
Does anyone know how to create a situation where the data o today-
will-
be on column A *, the data of tommorow will be on column
*etc.--
+-------------------------------------------------------------------+
|Filename: yahoo macro.zip * * * * * * * * * * * * * * * * * * * * *|
|Download:http://www.excelbanter.com/attachment.php?attachmentid=296|
+-------------------------------------------------------------------+

+-------------------------------------------------------------------
+-------------------------------------------------------------------
 
D

Don Guillett

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
==========
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.-
-
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|
+-------------------------------------------------------------------+

+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

You neglected to respond to my questions, sending a file with NO
explanation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top