Call of macros in modules via .vbs file

[mos]

hey guys,

I got the following setup:

I would like to execute this macro "updateNexportOpen" without Opening the xls file AND without using Workbook_Open event.

so I came across this code which I execute via a .vbs file

Dim objXL
Set objXL = CreateObject("Excel.Application")

on error resume next

With objXL 

    .Workbooks.Open ("Y:\...\DB saved.xls") 
    .Run "DB saved.xls!updateNexportOpen" 
    Application.Calculate
    .Quit

End With

Set objXL = Nothing

This seems quite good, as far as something happens (sandglass) AND Excel asks me "Do you want to save the changes?"
BUT this comes very fast, usually the 2 web queries take longer.

so maybe it doesnt execute anything and it does not save a text file, which it usually does. (neither I click save changes nor dont save changes).

so it probably does not execute the macro, even though it has some changes inside the file.

Someone has an idea what could cause that?

Thanks and regards,

mos



P.S. same macro works perfectly executed inside the xls with a butt*******

 

[mos]

the line

.Run "DB saved.xls!updateNexportOpen"

is supposed to be

.Run "updateNexportOpen"

with this only change it works.

maybe because the macro is in a module it is called in the application-universe instead calling it via the workbook.

cheers