F
Fredrik Wahlgren
Hi
The ability to control Office applications programmatically is something
that seems to be very important to lot of people. Whether you do so from an
add-in or an application such as SAP, PeopleSoft or MAple, it sure adds
value. I have mainly automated Excel using t he older Excel4 API. I have
also done COM addins using C++ and VB.
Unfortunately, Microsoft doesn't seem to think this is equally important on
the Mac. The Excel 97 SDK book doesn't mention tye Mac platform at all.
Still, it seems as if xll's are still supported, The Analysis toolpack tha
comes with Office 2004 for Mac is indeed an xll. Obviously, there's no 68K
code. Interestingly, it seems as if there's a new breed of add-ins. There's
the Euro Convert and the Solver add-in. These are shared libraries and they
interact with Excel using the Excel4 function. I know this since I used a
too that came with Xcode. If it did, it would export things like xlAutoOpen.
I would like to, if possible, to write such an add-in myself. Unfortunately,
nothing has been documented. The best information I have found shows how to
call a shared library (Carbon) from visual basic, There's no way to interact
with Excel from within the shlb. Isn't it likely to assume that the Solver
add-in somehow calls Excel?
I just want to know what your thoughts are on this matter. I think that the
ability to automate Office products is as useful to Mac developers as it is
to those that use Windows. Furthermore, I don't think RealBasic is enough, I
would like to use C++-
Best Regards,
Fredrik
The ability to control Office applications programmatically is something
that seems to be very important to lot of people. Whether you do so from an
add-in or an application such as SAP, PeopleSoft or MAple, it sure adds
value. I have mainly automated Excel using t he older Excel4 API. I have
also done COM addins using C++ and VB.
Unfortunately, Microsoft doesn't seem to think this is equally important on
the Mac. The Excel 97 SDK book doesn't mention tye Mac platform at all.
Still, it seems as if xll's are still supported, The Analysis toolpack tha
comes with Office 2004 for Mac is indeed an xll. Obviously, there's no 68K
code. Interestingly, it seems as if there's a new breed of add-ins. There's
the Euro Convert and the Solver add-in. These are shared libraries and they
interact with Excel using the Excel4 function. I know this since I used a
too that came with Xcode. If it did, it would export things like xlAutoOpen.
I would like to, if possible, to write such an add-in myself. Unfortunately,
nothing has been documented. The best information I have found shows how to
call a shared library (Carbon) from visual basic, There's no way to interact
with Excel from within the shlb. Isn't it likely to assume that the Solver
add-in somehow calls Excel?
I just want to know what your thoughts are on this matter. I think that the
ability to automate Office products is as useful to Mac developers as it is
to those that use Windows. Furthermore, I don't think RealBasic is enough, I
would like to use C++-
Best Regards,
Fredrik