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