[Excel] – Running Macro Automatically

Last update on November 1, 2009 09:34 AM by aakai1056
Published by aakai1056

[Excel] – Running Macro Automatically





Issue


I have a macro in excel which needs to be run twice a day and I don’t even want to open the excel sheet. How can I make this process automatic?

If I can convert the macro to Exe file, maybe I can put it to my task manager. Please advice.

Solution


Add the macro code to excel open event.
You can open an excel file and make it to run twice a day
by creating a new task and adding its path to "Scheduled Tasks" within double quotes under:
Start>>Programs>>Accessories>>System Tools
  • In the VBE window, in the 'Thisworkbook' page select workbook then add the following three lines:


Private Sub Workbook_Open() 
' add code here 
End Sub


workbooks("Workbookname").save

workbooks("Workbookname").close
  • Timing criteria:


If Hour(Time) = "24" then

Thanks to Excelguru for this tip on the forum.
Best answers for « – Running Macro Automatically » in :
Cell input to call macro in adjacent cell ShowCell input to call macro in adjacent cell Issue Solution Note Issue I have a scenario that i'd like automated. The scenario is as follows If i enter a value in any cell in a particular column, i want the system time to be entered...
How to log in automatically with Windows XP ShowHow to log in automatically with Windows XP Using the Run feature If you have recently updated your Windows with the Automatic Updates, you will notice that you will not be able to log automatically into your account. This is due...
Automatically Launch a program at PC startup ShowAutomatically Launch a program at PC startup The problem Solutions Not touching the registry By modifying the registry Disable its launch The problem Some programs such as Mozilla Firefox, Internet Explorer or the e-mail programs...
Download Super Macro ShowSuper macro is a free software which allows to create macro under Windows in order to activate diverse automatic actions. Apart being free, this software is easy to use and requires no knowledge in programming. You just simply click buttons, then...
Download Macro Mania Show
Download Caledos Automatic Wallpaper Changer ShowCaledos Automatic Wallpaper Changer, as its name indicates, is a screen background administrator. The main features of Caledos : - it supports the image formats BMP, GIF, JPG, TIF, - easy selection of files or folders, - the possibility of...
Introduction to Office Automation ShowWhat is office automation? The term office automation refers to all tools and methods that are applied to office activities which make it possible to process written, visual, and sound data in a computer-aided manner. Office automation is intended...
They need your help