Question on VBA Extensibility 5.3

Hi All


I wonder if anyone can help me please?

I have written a small Programme (Excel 97-20003 compatable) that requires a reference to VBA Extensibility 5.3. I wish to send this to a friend, for his use. (I have Excel 2007, he has Excel 2003).

What I am not clear on is whether references that have been set up on my computer remain intact when a Workbook is shipped to someone else.

His knowledge of Excel is limited, so I do not wish to explain how to set up the reference (it this is not the case).

I know that a reference can be set up progammatically, but I am not sure how to do this, so that it would work for Excel 2003 and Excel 2007.

Thank you in advance for any help or advice.

Regards
Wednesday

references are saved with the workbook so your reference should be fine

you're welcome :-)

please don't forget to mark your thread solved

The reference might not be the only problem.

Your friend will have to change security settings to allow programmatic access to the VBA Project.

click on Thread Tools at the top of the thread and then mark solved