Automation of running excel macros [Solved/Closed]

- Jun 10, 2009 at 07:53 AM - Latest reply:  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
See more 

11 replies

Best answer
Posts
261
Registration date
Saturday April 11, 2009
Last seen
June 21, 2011
- Jun 10, 2009 at 10:20 AM
24
Thank you
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)

Thank you, Excelguru 24

Something to say? Add comment

CCM has helped 1677 users this month

Ur awsum :)
9
Thank you
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
Posts
261
Registration date
Saturday April 11, 2009
Last seen
June 21, 2011
- Jun 14, 2009 at 07:40 AM
8
Thank you
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
Posts
261
Registration date
Saturday April 11, 2009
Last seen
June 21, 2011
> 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
Posts
27
Registration date
Saturday April 18, 2009
Last seen
November 22, 2012
>
Posts
261
Registration date
Saturday April 11, 2009
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
Posts
261
Registration date
Saturday April 11, 2009
Last seen
June 21, 2011
>
Posts
27
Registration date
Saturday April 18, 2009
Last seen
November 22, 2012
- Sep 3, 2009 at 02:59 AM
if Hour(Time) = "24" then
1
Thank you
Thanks a lot. You saved me so many working hours!
Hi Ped,
Can you share the solution?

Thanks,
Jennifer
Posts
4481
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
- Jun 16, 2010 at 04:16 AM