Re: $$Excel-Macros$$ Start and Stop Time - Macro

2013-06-22 Thread Bill Q
Thanks again Vabz. The problem is that although I am pretty certain that this is easy to write, I really have no background in VBA programming. On Saturday, June 22, 2013 7:13:34 AM UTC-4, Vabz wrote: > Hi > > For end time you can add one line ti check existing time with end time, if > exist

Re: $$Excel-Macros$$ Start and Stop Time - Macro

2013-06-22 Thread VBA VABZ
Hi For end time you can add one line ti check existing time with end time, if existing time is > end time then quit sub. HTH//Vabs On Sat, Jun 22, 2013 at 10:57 AM, Bill Q wrote: > Sounds good Vabz Half way there. What about the end time ? Where would > that go ? > On Friday, June 21, 201

Re: $$Excel-Macros$$ Start and Stop Time - Macro

2013-06-21 Thread Bill Q
Sounds good Vabz Half way there. What about the end time ? Where would that go ? On Friday, June 21, 2013 9:03:26 AM UTC-4, Vabz wrote: > > Hi > To run this macro, just make sure that you replace *Name_of_Macro* with > the name of the macro inside of your Excel workbook that you want to run.

Re: $$Excel-Macros$$ Start and Stop Time - Macro

2013-06-21 Thread VBA VABZ
Hi To run this macro, just make sure that you replace *Name_of_Macro* with the name of the macro inside of your Excel workbook that you want to run. Also, replace *09:30:00* with the time that you want your macro to run. Private Sub Workbook_Open() 'Runs a macro at 9:30 AM Application.OnTime Time

$$Excel-Macros$$ Start and Stop Time - Macro

2013-06-21 Thread Bill Q
I have various macros that perform different tasks daily. All of these have to be manually started and stopped at a certain time. That time is never the same as it has to be obviously initiated manually. I have read various examples on the web (for starting only), but have had no success so fa