Any Mac c++ programmers on here?

[Jason]

Someone contacted me regarding porting over to OSX an excel addin. I would
be using codewarrior 5 on an OSX machine. How doable is this with version 5?

Thanks

 

[Fredrik Wahlgren]

Someone contacted me regarding porting over to OSX an excel addin. I would
be using codewarrior 5 on an OSX machine. How doable is this with version 5?

Thanks

Is this an xll? It will be more complicated than the Excel 95 SDK suggests.
It documented 68k code. You now have to use CFM. Excel is not a Cocoa
application. I think it's doable, I managed to create a PPC version of a
subroutine that took too long under 68k emulation. BTW. How old is version
5?

/ Fredrik

 

[Fredrik Wahlgren]

Someone contacted me regarding porting over to OSX an excel addin. I would
be using codewarrior 5 on an OSX machine. How doable is this with version 5?

Thanks

You may want to post this message to the microsoft.public.excel.sdk
newsgroup as well.

/ Fredrik

 

[Jason]

Is this an xll? It will be more complicated than the Excel 95 SDK
suggests.
It documented 68k code. You now have to use CFM. Excel is not a Cocoa
application. I think it's doable, I managed to create a PPC version of a
subroutine that took too long under 68k emulation. BTW. How old is version
5?

/ Fredrik

It's an xla written in c++. I saw something from sailmaker which offered a
framework for creating the addin but it required a newer version of
codewarrior and the excel 95 sdk (which I cannot seem to locate any where).

I'm not sure of the release date of 5 but I know they're up to 9 now. I
would guess around 2000 that it came out. I don't have it in front of me but
the person who has it and is offering to let me use it to attempt this says
that it does have a patch for writing OSX code which is the version I'd like
to focus on the most.

I'm just wondering how hard of a conversion it will be. I'm not too
concerned with learning mac programming overall just getting this to work.

 

[Jason]

You may want to post this message to the microsoft.public.excel.sdk
newsgroup as well.

/ Fredrik

Thanks , I'll check it out .

 

[Fredrik Wahlgren]

It's an xla written in c++. I saw something from sailmaker which offered a
framework for creating the addin but it required a newer version of
codewarrior and the excel 95 sdk (which I cannot seem to locate any where).

I'm not sure of the release date of 5 but I know they're up to 9 now. I
would guess around 2000 that it came out. I don't have it in front of me but
the person who has it and is offering to let me use it to attempt this says
that it does have a patch for writing OSX code which is the version I'd like
to focus on the most.

I'm just wondering how hard of a conversion it will be. I'm not too
concerned with learning mac programming overall just getting this to work.

If a file has the extension xla, it's written in VBA. Are we talking about
the same thing? What does the add-in do? I think the most problematic part
is to understand how to make an add-in that doesn't use 68K code. I think it
would be a good idea to make a simple add-in first that simply adds a menu
ad possibly a few very simple UDF's.

/ Fredrik

 

[Jason]

If a file has the extension xla, it's written in VBA. Are we talking about
the same thing? What does the add-in do? I think the most problematic part
is to understand how to make an add-in that doesn't use 68K code. I think
it
would be a good idea to make a simple add-in first that simply adds a menu
ad possibly a few very simple UDF's.

/ Fredrik

Well it's a c++ project and I opened and built it in Visual Studio.Net and
it produced an xla file which I then "added in" to excel. It's an add in
that replaces some manual steps used to create charts and such. It's part of
a dissertation that this guy is writing.

Anyway, he has a powermac running osx 10.2 and codeworks 4 (was 5 but found
it to be 4) and we're trying to determine if CW 4 can even create add in's
for OSX or not and if so how much of a job this would be to convert it.

Are there any empty add in projects (perhaps from a SDK or even better an
add in wizard or something) that codeworks can build to see if it can do
this?

Thanks

 

[Fredrik Wahlgren]

Well it's a c++ project and I opened and built it in Visual Studio.Net and
it produced an xla file which I then "added in" to excel. It's an add in
that replaces some manual steps used to create charts and such. It's part of
a dissertation that this guy is writing.

Anyway, he has a powermac running osx 10.2 and codeworks 4 (was 5 but found
it to be 4) and we're trying to determine if CW 4 can even create add in's
for OSX or not and if so how much of a job this would be to convert it.

Are there any empty add in projects (perhaps from a SDK or even better an
add in wizard or something) that codeworks can build to see if it can do
this?

Thanks

Does it really have the xla extension?? Does the add-in you built with
VS.NET work? If the only purpose is for a dissertaion and it only replaces
afew manual steps, why not use VBA? Creating an excel add-in seems like
overkill.

/ fredrik

 

[Jason]

Does it really have the xla extension?? Does the add-in you built with
VS.NET work? If the only purpose is for a dissertaion and it only replaces
afew manual steps, why not use VBA? Creating an excel add-in seems like
overkill.

/ fredrik

Yeah it has an xla extension and it works good. It does quite alot, there's
33 .c files. I'm not sure when it was written but I think a while ago and
this guy is now tryng to get it wrapped up and needs a mac version.

The possiblity of creating a version using vba is definately a possibilty
but before I start doing that I'd like to see if I can convert it.

So do you think CW can create add ins?

 

[Fredrik Wahlgren]

Yeah it has an xla extension and it works good. It does quite alot, there's
33 .c files. I'm not sure when it was written but I think a while ago and
this guy is now tryng to get it wrapped up and needs a mac version.

The possiblity of creating a version using vba is definately a possibilty
but before I start doing that I'd like to see if I can convert it.

So do you think CW can create add ins?

How interesting. I guess Excel really doesn't care whether the extension is
xll or xla. It does use Excel4, right? With 33 c files, it seems as if it
does quite a lot. I hope it doesn't do anything that is specific to Windows.
If it does, it will be much harder to convert. I do know that the latest
version of Excel supports xll's since it comes with one. Other add-ins are
shared libraries, the creator type is 'shlb'. Unfortunately, MS hasn't
documented how other's can create this kind of add-in.

I will try to dig out what I can about xll's on Mac. The code is somewhere
on my Mac. I remember I used something called a RoutineDescriptor.

/ Fredrik

 

[Jason]

How interesting. I guess Excel really doesn't care whether the extension
is
xll or xla. It does use Excel4, right? With 33 c files, it seems as if it
does quite a lot. I hope it doesn't do anything that is specific to
Windows.
If it does, it will be much harder to convert. I do know that the latest
version of Excel supports xll's since it comes with one. Other add-ins are
shared libraries, the creator type is 'shlb'. Unfortunately, MS hasn't
documented how other's can create this kind of add-in.

I will try to dig out what I can about xll's on Mac. The code is somewhere
on my Mac. I remember I used something called a RoutineDescriptor.

/ Fredrik

uses excel4 ? It links with xlcall32.lib and works fine in my office xp
version of excel. It has alot of dialogs which then creates charts and
graphs and statistical information. I figure mac programming must have an
equivalent of dialog boxes and since we're dealing with excel it has built
in charts and "should" be somewhat similar programming despite the different
platforms.

Are there any frameworks for creating excel add ins or any sample code
around. I saw one by a sailmaker company but haven't looked at it yet.

 

[Fredrik Wahlgren]

uses excel4 ? It links with xlcall32.lib and works fine in my office xp
version of excel. It has alot of dialogs which then creates charts and
graphs and statistical information. I figure mac programming must have an
equivalent of dialog boxes and since we're dealing with excel it has built
in charts and "should" be somewhat similar programming despite the different
platforms.

Are there any frameworks for creating excel add ins or any sample code
around. I saw one by a sailmaker company but haven't looked at it yet.

If it links with xlcall32.lib, it's an xll allright. The Excel4 function is
used to communicate with Excel. How are the dialogs created? I think it's
using the Win32 API. In this case, it will be difficult to convert it. I
remember that Resorcer could create code given a DLOG resource. Unless you
have this tool and is willing to spend a great deal of time on this project,
I suggest you use VBA instead.

/ Fredrik

 

[Jason]

If it links with xlcall32.lib, it's an xll allright. The Excel4 function
is
used to communicate with Excel. How are the dialogs created? I think it's
using the Win32 API. In this case, it will be difficult to convert it. I
remember that Resorcer could create code given a DLOG resource. Unless you
have this tool and is willing to spend a great deal of time on this
project,
I suggest you use VBA instead.

/ Fredrik

Dialogs are in the resource file and init'd via a call like so

dlgHelpAbout = grabResource(lib, MAKEINTRESOURCE(IDD_HELPABOUT), RT_DIALOG);

Where does the resorcer program come from? I take it, it isn't part of the
codewarrior package.

At this point I'm not sure which would take more time, this way or VBA.

But thanks, I appreciate all the info you've told me so far.

 

[Fredrik Wahlgren]

Dialogs are in the resource file and init'd via a call like so

dlgHelpAbout = grabResource(lib, MAKEINTRESOURCE(IDD_HELPABOUT), RT_DIALOG);

Where does the resorcer program come from? I take it, it isn't part of the
codewarrior package.

At this point I'm not sure which would take more time, this way or VBA.

But thanks, I appreciate all the info you've told me so far.

Resorcer does not come with CW. I think it costs about $250. VBA will
definitely take less time.

/ Fredrik

 

[Fredrik Wahlgren]

I think it would be great if MS documented how to create add-ins on Excel
for Mac. If you agree, please submit a suggestion to them. I think you can
do this directly from Excel.

I'm surprised that MS hasn't done so. Being able to make add-ins is a big
deal on the Windows platform. Why shouldn't it be for Mac users?

/ Fredrik

 

[Jason]

Resorcer does not come with CW. I think it costs about $250. VBA will
definitely take less time.

/ Fredrik

Is there any type of dialog designer in CW? I haven't used CW alot but how
does one create dialogs in the mac world?

 

[Fredrik Wahlgren]

Is there any type of dialog designer in CW? I haven't used CW alot but how
does one create dialogs in the mac world?

It's been some time since I used CW but I think it only has a rather buggy
resource editor. I don't think CW has any kind of dialog editor capable of
generating code. I'm not 100% sure, though. You may want to post this
question to a Mac programming newsgroup.

/ Fredrik

 

[Paul Berkowitz]

Is there any type of dialog designer in CW? I haven't used CW alot but how
does one create dialogs in the mac world?

Do you suppose you could please start editing your replies? It's a very
interesting thread, but we've all got the whole thread already. We don't
have to re-read it 13 or 17 times. Since you're bottom-posting you should
also edit down to just what's immediately relevant, so we don't have to
scroll through acres of previous responses every time. (Or if you insist on
keeping it all, top-post.) Please just take those extra few seconds to edit
before writing, to make things easier on your readers. Fredrik has done so
once or twice but you keep letting it get all tangled again.

The purpose of a public newsgroup is to let all readers benefit. So please
help them benefit by respecting standard "netiquette". Thank you.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

 

[Fredrik Wahlgren]

Do you suppose you could please start editing your replies? It's a very

interesting thread, but we've all got the whole thread already. We don't
have to re-read it 13 or 17 times. Since you're bottom-posting you should
also edit down to just what's immediately relevant, so we don't have to
scroll through acres of previous responses every time. (Or if you insist on
keeping it all, top-post.) Please just take those extra few seconds to edit
before writing, to make things easier on your readers. Fredrik has done so
once or twice but you keep letting it get all tangled again.

The purpose of a public newsgroup is to let all readers benefit. So please
help them benefit by respecting standard "netiquette". Thank you.

Hi Paul

I find that I sometimes truncate old messages and sometimes I don't. I
understand it is good practice to do so.
Since I participate in many newsgroups, I will follow your recommendations
from now on.

/ Fredrik