Hi there,

I am still working with Access97/VBA (will change to 2003 soon).
I built mde systems that use automation with excel and others. When I compile the mde it uses my dll versions and if someone else has a later version (Excel for example) errors occur. I've got no idea how to solve this one...

Any help would greatly be appreciated and a big thanks already now...

Have a nice day...
Michael

Each version of Office has a newer library. So if you want to work with multiple version, you will have to code for each.

Rgds,
Anand M
VB.NET MVP
http://www.dotnetindia.com

"Michael" wrote:

> Hi there,
>
> I am still working with Access97/VBA (will change to 2003 soon).
> I built mde systems that use automation with excel and others. When I compile the mde it uses my dll versions and if someone else has a later version (Excel for example) errors occur. I've got no idea how to solve this one...
>
> Any help would greatly be appreciated and a big thanks already now...
>
> Have a nice day...
> Michael
>

Hi Michael,

I gues you can find some answers on your questions here

Office
http://support.microsoft.com/default...b;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en

I hope this answers your questions?

Cor

Wouldn't late binding your office objects using CreateObject work as well?
Our product automates word and we have no issues with differing versions
because we use late binding.

"Michael" <(E-Mail Removed)> wrote in message
news:3E8EE6F6-1369-4F24-8FD3-(E-Mail Removed)...
> Hi there,
>
> I am still working with Access97/VBA (will change to 2003 soon).
> I built mde systems that use automation with excel and others. When I
compile the mde it uses my dll versions and if someone else has a later
version (Excel for example) errors occur. I've got no idea how to solve this
one...
>
> Any help would greatly be appreciated and a big thanks already now...
>
> Have a nice day...
> Michael

I have always thought of late binding as a temporary patch, but not as a
desired solution because of the performance and instability associated with
it.


"Shawn Hogan" <NOSPAM> wrote in message
news:%(E-Mail Removed)...
> Wouldn't late binding your office objects using CreateObject work as well?
> Our product automates word and we have no issues with differing versions
> because we use late binding.
>
> "Michael" <(E-Mail Removed)> wrote in message
> news:3E8EE6F6-1369-4F24-8FD3-(E-Mail Removed)...
> > Hi there,
> >
> > I am still working with Access97/VBA (will change to 2003 soon).
> > I built mde systems that use automation with excel and others. When I
> compile the mde it uses my dll versions and if someone else has a later
> version (Excel for example) errors occur. I've got no idea how to solve
this
> one...
> >
> > Any help would greatly be appreciated and a big thanks already now...
> >
> > Have a nice day...
> > Michael
>
>