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
|