Automation of running excel macros

Solved/Closed
Ped - Jun 10, 2009 at 07:53 AM
 Aurorian - Oct 31, 2012 at 04:41 AM
Hello,

I have a macro in excel which needs to be run twice a day and I dont 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.

Many thanks

Ped
Related:

4 responses

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jun 10, 2009 at 10:20 AM
Hi
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)
Ur awsum :)
0
Hi and thanks a lot.

Now I can schedule opening the excel. What I don't know how to do is:

1. To add macro code to excel open event
2. To close the excel file and save it automatically.


Many thanks again

Ped
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jun 14, 2009 at 07:40 AM
Hi

1. 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
2.workbooks("Workbookname").save

workbooks("Workbookname").close
hi there,

i have a similar problem as posted by another user

i have used windows scheduler to open the workbook every night at 12

i need to run a particular macro from a particular module.

in my auto_open event I already have 3 macros which will run on start up. I need to skip these three macro and run my specific macro every night.

any help will b highly appreciated.

thanks
0
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307 > smd
Sep 3, 2009 at 02:46 AM
Put a condition for the 3 existing macros not to ru if time is 12 AM and add the new macro without this condition
0
smd_excel Posts 27 Registration date Saturday April 18, 2009 Status Member Last seen November 22, 2012 > Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011
Sep 3, 2009 at 02:52 AM
hi,
thanks for the reply but cud u help me with the code for creating the timing criteria
0
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307 > smd_excel Posts 27 Registration date Saturday April 18, 2009 Status Member Last seen November 22, 2012
Sep 3, 2009 at 02:59 AM
if Hour(Time) = "24" then
0
Thanks a lot. You saved me so many working hours!
Hi Ped,
Can you share the solution?

Thanks,
Jennifer
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 16, 2010 at 04:16 AM
0