locked
How to run excel macro without opening the workbook? RRS feed

  • 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...
    Saturday, March 7, 2009 10:33 AM

All replies

  • 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
    Saturday, March 7, 2009 10:56 AM
  • 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 !!
    Saturday, March 7, 2009 12:07 PM
  • Maybe this will help you along.

    http://www.devnewsgroups.net/group/microsoft.public.office.developer.outlook.vba/topic36620.aspx
    Cheers
    Saturday, March 7, 2009 2:13 PM