Workbook_open Event Not Working

I have a batch file that opens a workbook that has a workbook_open event associated with it.

When I run the batch file from a dos prompt it works fine and the workbook_open code is executed.

However, when I run the batch file using an Runtime.exec() java function within webMethods, the behavior is different. All of the code in the batch file is executed properly, except, when the workbook is opened, the workbook_open event does not run.

Does anybody have any ideas why the code doesn’t run?

Thanks for your reply Leith. I had first tried to use the auto_open macro in my spreadsheet, with the same results. I even changed the security setting to Low, so that it doesn't prompt me to enable/disable macros. I have the following code in my Workbook_open event:

Private Sub Workbook_Open()

    Application.DisplayAlerts = False
    Application.EnableEvents = True
    
    Open "c:\webMethods7\IntegrationServer\packages\PricingModel\doc\TESTFILE" For Output As #1    ' Open file for output.
        Print #1, "This is a test"    ' Print text to file.
    Close #1    ' Close file.

    
    ActiveWorkbook.XmlMaps("PricingInputs_Map").Import URL:= _
        "C:\webMethods7\IntegrationServer\packages\PricingModel\doc\PricingModelInput.xml"
    ActiveWorkbook.XmlMaps("PricingOutputs_Map").Export URL:= _
        "C:\webMethods7\IntegrationServer\packages\PricingModel\doc\PricingModelOutput.xml"
        
    Application.Quit

End Sub

As you can see, I put a few lines in the Workbook_open event that creates a testfile, so that I can see if the event kicks off at all. To reiterate, the code runs fine when the file is opened from a command prompt. The problem is when I use a java script function to execute a command line call.

Does workbook_open and auto_open not execute when called from a third party program? If so, is there another way to run a macro directly from the command prompt without relying on workbook_open and auto_open?

Please read the Forum Rules, and then edit your post to wrap your code with Code Tags.