View Single Post
  #5   Report Post  
eXcellence
 
Posts: n/a
Default

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