Object Library References not transferring

A

allenj3

I have an Excel VBA project that I need to transfer to other users (via
email). When they receive my Excel workbook, certain functions are not
working properly (e.g. the UCase() function). I suspect that not all of the
references to Object Libraries I'm using are transferring properly. I'm only
using standard Microsoft libraries so I think perhaps the paths are just
different on the user's PC.

Is there any way to ensure that references to Object Libraries are
maintained when a workbook is transferred to another PC?

Thanks.
 
J

Jim Thomlinson

Most likely the cause of your problem is using the latest version of
references, when your useres only have older versions. It is often a good
idea to use older versions of the libraries to ensure that your references
will exist on the host system.
 
A

allenj3

Thanks, Jim. I will give this a try. I'm not sure it will work though
because the only user I've sent this to so far has the same version of Excel
that I have. I'm having him send me a screenshot of his references to see
where the problem is.
 
J

Jim Thomlinson

Service packs alone can cause the problem even if the version is the same...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top