VBA References Q
I have some VBA code that e-mails an Excel file, this works fine (created in
Excel 2003).
This same file is issued to other PC's that Run Excel XP / 2000. The problem
that I am having on the XP / 2000 PC's is that I get a Compile error and it
appears to be because my "Microsoft outlook 11.0 Object Library" is missing.
When I manually select "Microsoft outlook 10.0 Object Library" on these Xp /
2000 machines everything works fine.
As I maintain the file on Excel 2003 how can I automatically select the
appropriate Outlook Object Library when other machines (other than Excel
2003) open it?
Thanks
|