$$Excel-Macros$$ Macro Modification

2015-06-19 Thread Bill Q
Hi Guys, Attached is a spreadsheet and macro that does some web-scraping of individual web pages.. I need two modifications on this macro that I do not know how to do as I have little experience. * Currently the macro will stop after it encounters about 32700 rows. I would like it to run to

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

2013-11-13 Thread Bill Q
I don't see anything else except your comment "sure". Am I missing something ? On Wednesday, November 13, 2013 3:21:51 AM UTC-5, Enrique Martin wrote: > Sure > > > On Wed, Nov 13, 2013 at 11:06 AM, Bill Q > > wrote: > >> >> On Thursday, December 13, 2012 8:48:25 PM UTC-5, Enrique Martin w

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

2013-11-13 Thread Anoop K Sharma
Sure On Wed, Nov 13, 2013 at 11:06 AM, Bill Q wrote: > > On Thursday, December 13, 2012 8:48:25 PM UTC-5, Enrique Martin wrote: > >> My Pleasure.. You have given me new title. >> >> >> On Fri, Dec 14, 2012 at 12:57 AM, Bill Q wrote: >> >>> Just what the doctor ordered. Thank you very m

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

2013-11-12 Thread Bill Q
On Thursday, December 13, 2012 8:48:25 PM UTC-5, Enrique Martin wrote: > > My Pleasure.. You have given me new title. > > > On Fri, Dec 14, 2012 at 12:57 AM, Bill Q > > wrote: > >> Just what the doctor ordered. Thank you very much Dr. Anoop. >> >> Much appreciated. >> >> >> >> On Th

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

2012-12-13 Thread Anoop K Sharma
My Pleasure.. You have given me new title. On Fri, Dec 14, 2012 at 12:57 AM, Bill Q wrote: > Just what the doctor ordered. Thank you very much Dr. Anoop. > > Much appreciated. > > > > On Thursday, December 13, 2012 1:59:22 AM UTC-5, Enrique Martin wrote: > >> Hi Bill, >> >> I have modif

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

2012-12-13 Thread Bill Q
Just what the doctor ordered. Thank you very much Dr. Anoop. Much appreciated. On Thursday, December 13, 2012 1:59:22 AM UTC-5, Enrique Martin wrote: > Hi Bill, > > I have modified the code which will work within stipulated time as > described above. > I have also provided two command butt

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

2012-12-12 Thread Bill Q
To be more specific. In this case I want to query the S&P 500 every minute between 09:00 and 16:30. Thanks for all your input. On Wednesday, December 12, 2012 10:09:26 AM UTC-5, Bill Q wrote: > From what I can see, it looks like this will interfere with the > runintervalminutes (whic

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

2012-12-12 Thread Bill Q
>From what I can see, it looks like this will interfere with the runintervalminutes (which is important to be seperate). Also, how to I get it to stop at a specific time ? On Wednesday, December 12, 2012 2:44:15 AM UTC-5, Enrique Martin wrote: > Hi Bill, > > There are two variable defined

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

2012-12-12 Thread Anoop K Sharma
RunWhen = TimeSerial(15, 0, 0). On Wed, Dec 12, 2012 at 2:38 PM, Anoop K Sharma wrote: > Hi Bill, > > Please see below. The RunWhen variable must be as below: > > RunWhen = Now + TimeSerial(15, 0, 0). > > > On Wed, Dec 12, 2012 at 1:14 PM, Anoop K Sharma wrote: > >> Hi Bill, >> >> There are two

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

2012-12-12 Thread Anoop K Sharma
Hi Bill, Please see below. The RunWhen variable must be as below: RunWhen = Now + TimeSerial(15, 0, 0). On Wed, Dec 12, 2012 at 1:14 PM, Anoop K Sharma wrote: > Hi Bill, > > There are two variable defined in your module. These are "RunWhen" and > "SaveWhen". > Both of them are being used with t

Re: $$Excel-Macros$$ Macro Modification Needed To Include Start/Stop Time

2012-12-11 Thread Anoop K Sharma
Hi Bill, There are two variable defined in your module. These are "RunWhen" and "SaveWhen". Both of them are being used with timeserial value. You can provide your desired time in this parameter(TimeSerial). Suppose you want to Run your code at 1500 hrs then you can modify your code as below: Run