VBA Help on Executing a Module at a Specific Time

G

gnaga

Well-known Member
Joined
Jul 9, 2002
Messages
748
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
Hi,

I would like to execute a VBA module at a specific time on daily basis. If my workbook is continuously kept opened then it can be accomplished using timer event but it is not the case here. To make it simple even if I want to keep it that open, somebody closes for nothing. How to overcome this and execute the code daily at morning 09:00 AM. Can somebody give/share your idea on this please.

TIA :pray:
GNaga
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Sort by date Sort by votes
Why cant you use the windows scheduler to open the file at 9:00 AM and then execute the VBA code with the "Private Sub Workbook_Open()"
command line, And if you want to close the work book at a specific time you can use the following command line.

Sub day()
Application.DisplayAlerts = False
Application.Quit
End Sub

hope this may of use to you..
 
Upvote 0
You must log in or register to reply here.

Similar threads

L
  • Solved
VBA Run-time Errors
Replies
3
Views
513
StephenCrump
S
R
  • Solved
VBA Timer
2
Replies
11
Views
973
Rana Gray
R
H
  • Question
VBA Code for date lookup and data transfer (god please help)
Replies
0
Views
411
hoofy
H
R
  • Solved
VBA set time delay before running the next macro line
Replies
2
Views
1K
Raychin
R
P
  • Question
Edit VBA code to add new attachment on Email
Replies
3
Views
276
Persl
P

Forum statistics

Threads
1,214,998
Messages
6,122,643
Members
449,093
Latest member
Ahmad123098

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top