View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Joergen Bondesen Joergen Bondesen is offline
external usenet poster
 
Posts: 110
Default Public function in Personal.xls

Hi Bob

It works perfect now.
Thanks for your patience.

--
Best regards
Joergen Bondesen


"Bob Phillips" wrote in message
...
Yes I am sure, it is just another workbook and it can be referenced as
such.
As long as you have a Personal.xls (and that is not a given, it has to be
created), you should see it in the list of references. As I mentioned to
Ardus, you may need to change the project name in Properties, so that it
is
unique, and identifiable in the list.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Joergen Bondesen" wrote in message
...
Hi Bob

set a reference to Personal.xls in your workbook

Are you sure about this, because I can not find Personal in Excel 2003
reference.
What must I look for?

--
Best regards
Joergen Bondesen


"Bob Phillips" wrote in message
...
Look at Application.Run in help, or set a reference to Personal.xls in
your
workbook, then you could call them as if they were locakl to your
workbook.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Ardus Petus" wrote in message
...
I have a series of utility functions in Personal.xls

I know how to call them from a worksheet cell.

What is the syntax to call them from VBA code?

TIA,
--
AP