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
>
>
>
Bookmarks