Word Macro Com+ component

[Michael Kieferle]

Hi newsgroup,

is there a way to create COM+ Components in office:mac VBA? I need
ADODB or MSXML to port my MS Office 2000 (PC) Macros to office:mac.

Thanks for help
Michael

 

[Fredrik Wahlgren]

Hi newsgroup,

is there a way to create COM+ Components in office:mac VBA? I need
ADODB or MSXML to port my MS Office 2000 (PC) Macros to office:mac.

Thanks for help
Michael

COM+ and ADO are only available in Windows. I'm not sure what you wnat to
do. You can use an ODBC connection to get values from a dtabase into Excel.
Why do you want to create COM+ components?

Best Regards,
Fredrik

 

[Daiya Mitchell]

Why do you need a COM+ Component (whatever that is) to port Office macros
over? Anything that works in VBA 5 (Office 97) should work on the Mac.
Active-X will not work on the Mac, but I think it is possible to build
substitutes from VBA.

 

[Michael Kieferle]

Thanks for your replies.

I wrote for our Company Word Templates a lot of Macros in Word 2000
with ADO to conect to our CRM-System (based on a SQL DB). Cuz my Boss
replaced some PCs with Macs we need these Templates on office:mac. So
im looking for a way to get the OfficeC based Templates working on
Mac. So i need a way to connect to the DB or read a XML-Export. The
ActiveX-Components ADO or MSXML would do...
But if you say, the won't work, i must find an other way :/

Michael

 

[Fredrik Wahlgren]

Thanks for your replies.

I wrote for our Company Word Templates a lot of Macros in Word 2000
with ADO to conect to our CRM-System (based on a SQL DB). Cuz my Boss
replaced some PCs with Macs we need these Templates on office:mac. So
im looking for a way to get the OfficeC based Templates working on
Mac. So i need a way to connect to the DB or read a XML-Export. The
ActiveX-Components ADO or MSXML would do...
But if you say, the won't work, i must find an other way :/

Michael

Can you use ODBC?

/Fredrik

 

[Michael Kieferle]

Hi Fredrik,

it seems, that only Excel is able to use ODBC with Query X.

see: http://groups.google.de/[email protected]&rnum=1

Michael