Re: Any Mac c++ programmers on here?

From: Fredrik Wahlgren (fredrik.p.wahlgren_at_mailbox.swipnet.se)
Date: 12/28/04


Date: Tue, 28 Dec 2004 22:56:41 +0100


"Jason" <yo@yo.com> wrote in message
news:u78JzaS7EHA.3336@TK2MSFTNGP11.phx.gbl...
>
> "Fredrik Wahlgren" <fredrik.p.wahlgren@mailbox.swipnet.se> wrote in
message
> news:Oq4VjTS7EHA.2156@TK2MSFTNGP10.phx.gbl...
> >
> > "Jason" <yo@yo.com> wrote in message
> > news:uglAFIS7EHA.2012@TK2MSFTNGP15.phx.gbl...
> >>
> >> "Fredrik Wahlgren" <fredrik.p.wahlgren@mailbox.swipnet.se> wrote in
> > message
> >> news:O7PQDqQ7EHA.4064@TK2MSFTNGP10.phx.gbl...
> >> >
> >> > "Jason" <yo@yo.com> wrote in message
> >> > news:OWyIwpP7EHA.3368@TK2MSFTNGP10.phx.gbl...
> >> >>
> >> >> "Fredrik Wahlgren" <fredrik.p.wahlgren@mailbox.swipnet.se> wrote in
> >> > message
> >> >> news:u5OuK8O7EHA.2608@TK2MSFTNGP10.phx.gbl...
> >> >> >
> >> >> > "Jason" <yo@yo.com> wrote in message
> >> >> > news:u5OCd1O7EHA.3416@TK2MSFTNGP09.phx.gbl...
> >> >> >> 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
> >> >> >
> >> >> >
> >> >>
> >> >> 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
> >> >
> >> >
> >>
> >> 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
> >
> >
>
> 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



Relevant Pages

  • Re: Excel 2008
    ... Mac 2008, ... Add-ins for Excel 2008? ... but there is no analysis tool pack for Excel 2008. ... The ATP wizards which helped you apply the functions are missing, ...
    (microsoft.public.mac.office)
  • Re: Testing Reverse Compatibility and Compatibility in General
    ... You need to have access to all appropriate versions of Excel, ... Excel using versions available on my many Windows computers. ... My add-ins run entirely within the Excel environment, ... you'll need access to a Mac or a reliable someone with a Mac. ...
    (microsoft.public.excel.misc)
  • Re: XLL file for MAC Excel?
    ... If the add-ins were written for the PC they will _not_ run on a Mac... ... Unless you are running the Windows version of Excel in Virtual PC. ... > figure out how to get the MAC excel program to recognize them. ...
    (microsoft.public.mac.office.excel)
  • Re: Any Mac c++ programmers on here?
    ... I think it would be great if MS documented how to create add-ins on Excel ... please submit a suggestion to them. ... Why shouldn't it be for Mac users? ...
    (microsoft.public.mac.office.excel)
  • Re: Worksheet unexpectedly disappears
    ... Excel 2004 for Mac v 11.3 ... No add-ins that I am aware of. ... No other 3rd party sw that I am aware of. ... What version of Excel & Mac OS? ...
    (microsoft.public.mac.office.excel)