Re: Sending Web Queries to Excel

2007-03-21 Thread Josep

Hi list,

Thanks Bryan for sending the link and thanks Ken to build and offer these
cool pieces of code. :) 
The script to exchange data Rev  Excel is great.

Thanks again,
Josep



Bryan McCormick wrote:
 
 I have been looking at Ken Ray's scripts for exchanging data from a 
 worksheet to and from RunRev and Excel.
 
 I also see that Gary Rathbone had a tutorial on Web Queries and Excel 
 but I cannot find that information anywhere on it (Gary site appears to 
 be gone). Does anyone have any idea where this is?
 
 I'd appreciate guidance on how to send the query in VB form to Excel. I 
 can see how to get the data back once it is on a sheet, so that isn't an 
   issue.
 
 The reason for needing to send the query in script form is that there is 
 a requirement to do a large batch. I could do it all in Excel, but as it 
 turns out munging the data is actually a lot easier once it is in RunRev.
 
 Thanks so much.
 ___
 use-revolution mailing list
 use-revolution@lists.runrev.com
 Please visit this url to subscribe, unsubscribe and manage your
 subscription preferences:
 http://lists.runrev.com/mailman/listinfo/use-revolution
 
 

-- 
View this message in context: 
http://www.nabble.com/Sending-Web-Queries-to-Excel-tf3429955.html#a9590469
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution


Sending Web Queries to Excel

2007-03-19 Thread Bryan McCormick
I have been looking at Ken Ray's scripts for exchanging data from a 
worksheet to and from RunRev and Excel.


I also see that Gary Rathbone had a tutorial on Web Queries and Excel 
but I cannot find that information anywhere on it (Gary site appears to 
be gone). Does anyone have any idea where this is?


I'd appreciate guidance on how to send the query in VB form to Excel. I 
can see how to get the data back once it is on a sheet, so that isn't an 
 issue.


The reason for needing to send the query in script form is that there is 
a requirement to do a large batch. I could do it all in Excel, but as it 
turns out munging the data is actually a lot easier once it is in RunRev.


Thanks so much.
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution