YAY !!!
Many Thanks Bob .. I tried your call
Have you tried?
MsgBox application.run("Excel_Library=AD3.xla!get_date()" )
But i needed to remove the ().
so MsgBox application.run("Excel_Library=AD3.xla!get_date")
works like a charm.
I will leave the code that installs the newest version of the XLA from
the network though, as it keeps the version that its calling up to
date.
Many Many application.run("Thanks.xla!Heaps")
eXcellence
|