"Andrew Yates" wrote in message
oups.com...
"Set mSession = New BS.Session " caused an invalid use of new keyword
error.
"Set mSession = CreateObject("BS.Session") " causes an "automation
error, unspecified error".

Hi Andrew,

Are you sure this BS.Session object is designed to be used from VBA? Are
you able to reference the BS object library (or whatever its friendly name
is) using the Tools/References menu?

I don't know anything about what the BS.Session object is, but if it is
designed to work with VBA then either it doesn't expose events that you can
trap using the WithEvents keyword in your variable declaration or it's not a
creatable class, which means you need to go through some other object in the
BS object library in order to get a reference to it.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm