Remove missing references VBA

[jdawg_1989]

Evening All,

I have a spreadsheet that gets distributed to my clients. They use the spreadsheet as a form to fill in various details.

On the spreadsheet I have a tab that my admin team use where there VBA code that creates records in an MS Access database based on information provided on form.

The problem I have is this, after my clients fill out the form they click a macro which attaches the spreadsheet to an email and sends it.

But......it falls over if the client does not have access on their machine as the VBA code that my admin team uses, uses the Access Reference Library in VBA.

How can I get around this? I'm thinking to have an error clause that can somehow remove the access reference if error?

Any thoughts please?

Thanks.

 

[jdawg_1989]

All for info, I've managed to solve this.

I have changed my code to use Late Binding instead of early binding. This way I can get rid of the Access Reference all together. This totally aviods the problem I was having

For those who may be interested, details on late binding can be found here.

http://www.mrexcel.com/forum/showthread.php?t=446485

Thanks.