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