Stephen,
I tried to remove the Office references as you suggested which I was able to
do for those from Office specifically, except for the Excel 11.0 Library-it
gave an error message that the file was in use. My application runs in Excel.
So do you have any suggestions on how I can get around this to remove this
reference?
Thanks
Van

"VanS" wrote:

> Thanks for your helpful response, Stephen. God bless
> Van
>
> "Stephen Bullen" wrote:
>
> > Hi VanS,
> >
> > > I am trying to make it compatible with earlier versions of Office-Office 97
> > > on a Win 98 platform at present-and after researching have decided to try
> > > late binding.
> >
> > To use late binding, you do the following:
> >
> > 1. Remove any references to the object models, in Project > References
> > 2. Declare all object variables that refer to the object models As Object
> > 3. Replace any constants defined in those object models with their numeric
> > equivalents.
> > 4. Use CreateObject("Appname") instead of 'New Appname' to create new
> > instances of the objects.
> >
> > If you do that, you shouldn't have any references problems, as you won't have
> > any references!
> >
> > Regards
> >
> > Stephen Bullen
> > Microsoft MVP - Excel
> > www.oaltd.co.uk
> >
> >
> >