Search : in
By :

Run excel workbook and macro automatically

Last answer on Aug 10, 2009 9:45:05 am BST smd, on Aug 10, 2009 8:54:21 am BST 
 Report this message to moderators

Hello,

i got a workbook with alot of macros in it. i need to open the workbook automatically every nite at 12 and run a particular macro and then close the workbook. there shud b no user intervention.

any help will be much appreciated.

thanks alot

Configuration: Windows XP
Firefox 3.0.11

Best answers for « run excel workbook and macro automatically » in :
[Excel] – Running Macro Automatically Show [Excel] – Running Macro Automatically Issue Solution Issue I have a macro in excel which needs to be run twice a day and I don’t even want to open the excel sheet. How can I make this process automatic? If I can convert the macro...
Run macro automatically (Solved) Show
Excel Macro - Set and autofill a range? Show
Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Download Excel Macro Processor Show
Download Super Macro ShowSuper macro is a free software which allows to create macro under Windows in order to activate diverse automatic actions. Apart being free, this software is easy to use and requires no knowledge in programming. You just simply click buttons, then...
Ask your question Reply

1

 kaiyasit, on Aug 10, 2009 9:45:05 am BST
  • +1

I think you can use ....
"Scheduled Tasks" in system tool of WinXp
and set up time to run your workbook

in your workbook ....you must create VBA to run your macro by use event "ON OPEN"

may be help u

   
Reply to kaiyasit
Ask your question Reply
They need your help