deploying excel with a vb project

[anthony]

Hi

I am distributing a vb project that opens up and runs excel macros. When I
distribute the package it install fine but as soon as a spreadsheet is
opened I am getting errors and I have found that there are missing reference
in the sheets.

When I package the VB project I add the sheets to it but it does not find
the references that the sheets need.

Does anyone have an idea how I can package a VB project with Excel
spreadsheets that contain references and have the VB project detect the
references and add it.

Thank you
ant

 

[Bob Phillips]

Anthony,

Do you really mean VB, or is it VBA in a workbook?

Do you want to show the code that starts everything off, and explain what
you are doing?