Thread
:
Public function in Personal.xls
View Single Post
#
9
Posted to microsoft.public.excel.programming
Dave Peterson
external usenet poster
Posts: 35,218
Public function in Personal.xls
I think you should try application.run using a function.
I bet it works.
Ardus Petus wrote:
Application.Run is OK for a Sub, not a Function.
Setting a reference to Personal.xls fails: "Module name, project name or
library name already in use"
Cheers
--
AP
"Bob Phillips" a écrit dans le message de news:
...
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
--
Dave Peterson
Reply With Quote
Dave Peterson
View Public Profile
Find all posts by Dave Peterson