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
> existing time is > end time then quit sub.
>
> HTH//Vabs
>
>
> On Sat, Jun 22, 2013 at 10:57 AM, Bill Q <ronsm...@gmail.com <javascript:>
> > wrote:
>
>> 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.
>>> 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 TimeValue("09:30:00"), "Name_of_Macro"
>>>
>>> End Sub
>>>
>>>
>>> On Fri, Jun 21, 2013 at 6:28 PM, Bill Q <ronsm...@gmail.com> wrote:
>>>
>>>> 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 far.
>>>>
>>>> Is there some simple code that I can insert into my existing code where
>>>> I can configure the start and stop times of the macro ? These spreadsheets
>>>> would stay open, so I assume that it would have to check the current time
>>>> every minute or so to see if it is time to start again or to stop.
>>>>
>>>> Many thanks.
>>>>
>>>> --
>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>>> https://www.facebook.com/**discussexcel<https://www.facebook.com/discussexcel>
>>>>
>>>> FORUM RULES
>>>>
>>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros...@**googlegroups.com.
>>>> To post to this group, send email to excel-...@googlegroups.com.
>>>>
>>>> Visit this group at
>>>> http://groups.google.com/**group/excel-macros<http://groups.google.com/group/excel-macros>
>>>> .
>>>> For more options, visit
>>>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out>
>>>> .
>>>>
>>>>
>>>>
>>>
>>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros...@googlegroups.com <javascript:>.
>> To post to this group, send email to excel-...@googlegroups.com<javascript:>
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/groups/opt_out.
>>
>>
>>
>
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.
