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

Macros or vba is a type of which automation
How to type # in laptop - Guide
Keyboard won't type - Guide
How many types of whatsapp are available - Guide
Vba case like - Guide
How to type e with accent - Guide

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

Subscribe To Our Newsletter!