Macro Execution

  • Thread starter Thread starter C Brandt
  • Start date Start date
C

C Brandt

This should be simple, but I cannot find an example.

What I want to do, is every morning, at 3:00 AM, auto execute a macro that
will rename data files. The reason for this is that another auto-executed
routine will be downloading new data into my system from another location
and likes to use the same filename every day.

In a blank spreadsheet, I've written the procedure that accomplishes the
renaming, but am at a lose as to how to auto execute it, when the sheet is
opened. Since I am unfamiliar with the world of object oriented programming,
example coding is the best way to get me started. Thank you.

I am now off looking for a way to schedule the spreadsheet to be opened
every morning at 3.

Any ideas?

Craig
 
You could use Windows Task Scheduler to fire up Excel and your workbook at
3:00am.

The workbook would have workbook_open code to run the macro.

Private Sub Workbook_Open()
macroname or code goes here
End Sub

Entered in Thisworkbook module.

Or in a general module

Sub Auto_Open()
macroname or code goes here
End Sub

You could add to your code to close Excel when done

Application.Quit


Gord Dibben MS Excel MVP
 
Back
Top