I need to create template to work with Word 2000, XP and 2003. It uses
references to Excel Object library which is different for all different
versions of Office. Is it possible to create one template to serve all
different versions of Office or rather I need to create the additional
template which will check the version of office and then call template
suitable for particular version to avoid error resulting from missing
reference to Excel library ?
Thanks for advice.
Tony
Dr. Stephan Kassanke - 14 Oct 2005 13:45 GMT
> I need to create template to work with Word 2000, XP and 2003. It uses
> references to Excel Object library which is different for all
[quoted text clipped - 7 lines]
>
> Tony
Tony, you can stick to one template if you use late binding for referencing
excel.
Stephan
Jonathan West - 14 Oct 2005 13:58 GMT
Hi Tony,
if you create the template in the earliest version of Word that you support,
and set a reference in the VBA project to the equivalent version of Excel,
then the reference will still work when the template is used in later
versions of office.
Of course, you should thoroughly test the template in all versions you want
to support, to make sure that no changes of behavior between versions affect
the operation of the template

Signature
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
>I need to create template to work with Word 2000, XP and 2003. It uses
> references to Excel Object library which is different for all different
[quoted text clipped - 7 lines]
>
> Tony