Previous Topic Next Topic

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

Answer 1 / 4
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)
Aurorian
Oct 31, 2012 at 04:41 AM
Ur awsum :)
Answer 2 / 4
Ped
Jun 10, 2009 at 03:08 PM
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
Answer 3 / 4
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
smd
Sep 3, 2009 at 12:52 AM
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
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
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
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
Answer 4 / 4
Ped
Jun 14, 2009 at 01:30 PM
Thanks a lot. You saved me so many working hours!
Jennifer
Jun 15, 2010 at 05:37 PM
Hi Ped,
Can you share the solution?

Thanks,
Jennifer
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 16, 2010 at 04:16 AM
See this
https://ccm.net/forum/affich-106434-automation-of-running-excel-macros#3

and this
https://ccm.net/forum/affich-106434-automation-of-running-excel-macros#1

answers on thread