Automation of running excel macros

Solved/Closed

Ped - 10 Jun 2009 à 07:53
Aurorian - 31 Oct 2012 à 04:41

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

Macros or vba is a type of which automation
How to type ' on keyboard - Guide
Excel online macros - Guide
Keyboard won't type - Guide
Refer to the graphic what type of cabling is shown - Guide
Vba find - Guide

4 responses

Réponse 1 / 4

Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
10 Jun 2009 à 10:20

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
31 Oct 2012 à 04:41

Ur awsum :)

Réponse 2 / 4

Ped
10 Jun 2009 à 15:08

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

Réponse 3 / 4

Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
14 Jun 2009 à 07:40

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
3 Sep 2009 à 00:52

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 11 April 2009 Status Member Last seen 21 June 2011 307 > smd
3 Sep 2009 à 02:46

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 18 April 2009 Status Member Last seen 22 November 2012 > Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011
3 Sep 2009 à 02:52

hi,
thanks for the reply but cud u help me with the code for creating the timing criteria

Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307 > smd_excel Posts 27 Registration date Saturday 18 April 2009 Status Member Last seen 22 November 2012
3 Sep 2009 à 02:59

if Hour(Time) = "24" then

Réponse 4 / 4

Ped
14 Jun 2009 à 13:30

Thanks a lot. You saved me so many working hours!

Jennifer
15 Jun 2010 à 17:37

Hi Ped,
Can you share the solution?

Thanks,
Jennifer

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
16 Jun 2010 à 04:16

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

Subscribe To Our Newsletter!