I have an Excel workbook (Automate_WTI.xls) with three sheets - Sheet1,
Sheet2 and Sheet3. I wrote some VBA code under the Auto_Open routine in
the module file so that it will execute automatically when the XLS is
loaded. The code in this routine performs three basic things:

1. Loads an Excel Add-In.
2. Makes calls to this add-in to retrieve data from an external database
over the WAN and populates the Sheets.
3. Sends output to a network printer

Then I wrote a VB6 frontend to call the above Workbook. My goal is to have a
VB wrapper, which loops through a network folder; processes each workbook it finds.
The end result is to setup one single VB EXE in Windows 2000 Task Scheduler
to execute at certain time. Here's the test VB code I have:

Private Sub Command1_Click()


Dim xl As Excel.Application
Dim wkb As Excel.Workbook
Dim wks As Excel.Worksheet
Dim apppath As String

apppath = App.Path & "\" & "Automate_WTI.xls"

Set xl = New Excel.Application
xl.Visible = True

Set wkb = xl.Workbooks.Open(FileName:=apppath)

wkb.RunAutoMacros xlAutoOpen

'wkb.Save
'wkb.Close
'xl.Quit
'Set wks = Nothing
'Set wkb = Nothing
'Set xl = Nothing

End Sub


The problem I am having is when I invoke the VB EXE, I can see it loads my
workbook but puts me in debug mode with an error on this line in Auto_Open
routine and the error message is "Object Required"

Application.Run "Login", strMyLogin, strMyPasswd <-- stops here in debug mode

The above line makes a call to the Add-In to login to the external database.

Can someone provide some help and explain to me what I need to fix this? My
Excel/VBA skill is limited but good in VB.

Thank you in advance!!!


Sydney Luu

Sydney,

Try adding the add-in workbook name to the Application.Run call...
( note the exclamation point that separates the workbook name from the sub routine )

Application.Run "MyAddInName.xla!Login, strMyLogin, strMyPasswd"

Regards,
Jim Cone
San Francisco, CA

wrote in message
om...

-snip-

The problem I am having is when I invoke the VB EXE, I can see it loads my
workbook but puts me in debug mode with an error on this line in Auto_Open
routine and the error message is "Object Required"
Application.Run "Login", strMyLogin, strMyPasswd <-- stops here in debug mode
The above line makes a call to the Add-In to login to the external database.
Can someone provide some help and explain to me what I need to fix this? My
Excel/VBA skill is limited but good in VB.
Thank you in advance!!!
Sydney Luu

Thanks for responding. This did not help fix the problem - still get
"Object Required" on that line.


"Jim Cone" wrote in message ...
Sydney,

Try adding the add-in workbook name to the Application.Run call...
( note the exclamation point that separates the workbook name from the sub routine )

Application.Run "MyAddInName.xla!Login, strMyLogin, strMyPasswd"

Regards,
Jim Cone
San Francisco, CA

wrote in message
om...

-snip-

The problem I am having is when I invoke the VB EXE, I can see it loads my
workbook but puts me in debug mode with an error on this line in Auto_Open
routine and the error message is "Object Required"
Application.Run "Login", strMyLogin, strMyPasswd <-- stops here in debug mode
The above line makes a call to the Add-In to login to the external database.
Can someone provide some help and explain to me what I need to fix this? My
Excel/VBA skill is limited but good in VB.
Thank you in advance!!!
Sydney Luu

Instead of 'Application', use the application object you created
with the Set New statement. E.g.,

xl.Run ....


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




wrote in message
om...
Thanks for responding. This did not help fix the problem -
still get
"Object Required" on that line.


"Jim Cone" wrote in message
...
Sydney,

Try adding the add-in workbook name to the Application.Run
call...
( note the exclamation point that separates the workbook name
from the sub routine )

Application.Run "MyAddInName.xla!Login, strMyLogin,
strMyPasswd"

Regards,
Jim Cone
San Francisco, CA

wrote in message
om...

-snip-

The problem I am having is when I invoke the VB EXE, I can
see it loads my
workbook but puts me in debug mode with an error on this
line in Auto_Open
routine and the error message is "Object Required"
Application.Run "Login", strMyLogin, strMyPasswd <-- stops
here in debug mode
The above line makes a call to the Add-In to login to the
external database.
Can someone provide some help and explain to me what I need
to fix this? My
Excel/VBA skill is limited but good in VB.
Thank you in advance!!!
Sydney Luu