How to run excel macro without opening the workbook?

Question

Hi,

I have written a excel macro which i want to run without opening the excel book.
i dont know if it is possible, if it is possible please help.

Thanks in advance...

Answer 1

Hi,

If the  codes in a workbook then Excel and the workbook need to be loaded/open.

What does the code do that would not require the workbook to be open?
Perhaps you could use VBScript instead of VBA

---

Cheers

Answer 2

Thanks for the option suggested.

Actually i have written code to mail list of people,its workin fine if i run the macro but i want to run that macro at particular time say everyday 02:00 pm.i have used windows scheduler to open the excel book n i have written code in workbook_open() to call that macro which is written in module.i want this process to be done through programming.

Please do let me know if any way i can  run macro without opening the excel sheet.
Code will be more helpful.

Thanks in advance !!

Answer 3

Maybe this will help you along.

http://www.devnewsgroups.net/group/microsoft.public.office.developer.outlook.vba/topic36620.aspx

---

Cheers