User Defined Fns.

[jmk1]

Does Office 2008 have the capability to let a user define functions that can then be used in a worksheet cell or stored in something like an add-in so that multiple workbooks can access it? For example, I normally use an add-in to give the properties of water/steam as a fn(P,T).

Without this capability, it is worthless to me.

 

[Jim Gordon MVP]

Hi,

Visual Basic add-ins are no longer supported in Office 2008.

Older XLM macros continue to be supported. You can download the XML macro
reference language documentation from this URL
http://www.microsoft.com/downloads/details.aspx?FamilyID=00d31943-3ad1-4df1-
9f93-c19c7e84f01c&DisplayLang=en

The visual basic object model is still available via AppleScript. Here¹s how
to use it:
http://www.mactech.com/vba-transition-guide/

Perhaps one of these less than great options will suffice.

-Jim

Does Office 2008 have the capability to let a user define functions that can
then be used in a worksheet cell or stored in something like an add-in so that
multiple workbooks can access it? For example, I normally use an add-in to
give the properties of water/steam as a fn(P,T).

Without this capability, it is worthless to me.

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Ian Kennedy]

Hi,

Visual Basic add-ins are no longer supported in Office 2008.

Older XLM macros continue to be supported. You can download the XML
macro reference language documentation from this URL
http://www.microsoft.com/downloads/...43-3ad1-4df1-9f93-c19c7e84f01c&DisplayLang=en
<http://www.microsoft.com/downloads/...43-3ad1-4df1-9f93-c19c7e84f01c&DisplayLang=en>

The visual basic object model is still available via AppleScript. Here’s
how to use it:
http://www.mactech.com/vba-transition-guide/

Perhaps one of these less than great options will suffice.

-Jim

What about XLL addins (ie written in C++), can anyone point me to
documentation on how to create XLL addins for the Mac.
Thanks
Ian