Where are the add-ins in Office 2008?

In article <ee88e1d.2.DeleteThis@webcrossing.caR9absDaxw>, <> wrote:

> Just wondering if it's just Excel? Do Powerpoint or Word add-ins work?

No add-ins which are written in VBA, or rely on the VBA functionality
that's been taken out of Office 2008 will work.

I don't know of any Word or PPT add-ins that will work with Office 08.
 >> Stay informed about: Where are the add-ins in Office 2008? 

Hi Alexander:

Office 2008 does not have an Analysis Toolpack. You have to use the
built-in functions.

The Analysis toolpack relied on VBA, so it can't operate in Office 2008.
The functions have been moved into Excel as native functions in this
release.

Cheers


On 17/01/08 8:05 AM, in article
bbe16334-e3df-44d3-9925-52af7969d221.DeleteThis@k39g2000hsf.googlegroups.com,
"Alexander Malov" <alxmlv.DeleteThis@gmail.com> wrote:

> I just installed Mac Office 2008 and I am unable to find any add-ins
> in Excel (Tools > Add-ins). I rely on the statistical add-in quite a
> bit for school work. I wasn't prompted for anything during the
> installation. Thanks.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, Northern Territory, Australia
+61 4 1209 1410, mailto:john@mcghie.name
 >> Stay informed about: Where are the add-ins in Office 2008? 

"John McGhie" <john.DeleteThis@mcghie.name> wrote in message
news:C3B57F99.DF1A%john@mcghie.name...
> Hi Alexander:
>
> Office 2008 does not have an Analysis Toolpack. You have to use the
> built-in functions.
>
> The Analysis toolpack relied on VBA, so it can't operate in Office 2008.
> The functions have been moved into Excel as native functions in this
> release.


Not all of them have. The vast majority are AWOL.
 >> Stay informed about: Where are the add-ins in Office 2008? 

In article <D1F7429C-7758-4B6C-ABFD-AC7A715D6CAB.RemoveThis@microsoft.com>,
"John" <nospam.RemoveThis@nospam.com> wrote:

> "John McGhie" <john.RemoveThis@mcghie.name> wrote in message
> news:C3B57F99.DF1A%john@mcghie.name...
> > Hi Alexander:
> >
> > Office 2008 does not have an Analysis Toolpack. You have to use the
> > built-in functions.
> >
> > The Analysis toolpack relied on VBA, so it can't operate in Office 2008.
> > The functions have been moved into Excel as native functions in this
> > release.
>
>
> Not all of them have. The vast majority are AWOL.

Which functions are missing?
 >> Stay informed about: Where are the add-ins in Office 2008? 

Really, the answer to this is "No: no add-ins anywhere in Office 2008".

Essentially, Office 2008 is like any modern application suite, it's a set of
core modules ("the engine") that does the work, and a set of "skins" (user
interfaces) that make the engine look like Word or Excel or PowerPoint.

Since the Engine has no VBA interpreter, add-ins don't work anywhere.

If you wanted to be totally pedantic, Excel has a different concept of
"add-ins" to Word and PowerPoint.

For example: Global Templates will work in Word. These can contain
Document Parts, which could be considered "add-ins". If they do, and they
are amongst the types of Document Parts implemented in Office 2008, then
they will work in Word 2008.

However: As JE says, anything that contains "executable code" will NOT
work.

Cheers

On 18/01/08 3:16 AM, in article ee88e1d.2.DeleteThis@webcrossing.caR9absDaxw, "" <>
wrote:

> Just wondering if it's just Excel? Do Powerpoint or Word add-ins work?

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, Northern Territory, Australia
+61 4 1209 1410, mailto:john@mcghie.name
 >> Stay informed about: Where are the add-ins in Office 2008? 

Are you sure?

Our resident Excel Expert, JE McGimpsey has challenged people to identify an
analysis you can't do with the built-in functions in E2008 :-)

OK, they're a PITA to code, in some cases, but they are "possible" :-)

Cheers

On 18/01/08 4:07 PM, in article
D1F7429C-7758-4B6C-ABFD-AC7A715D6CAB.RemoveThis@microsoft.com, "John"
<nospam.RemoveThis@nospam.com> wrote:

>
> "John McGhie" <john.RemoveThis@mcghie.name> wrote in message
> news:C3B57F99.DF1A%john@mcghie.name...
>> Hi Alexander:
>>
>> Office 2008 does not have an Analysis Toolpack. You have to use the
>> built-in functions.
>>
>> The Analysis toolpack relied on VBA, so it can't operate in Office you can't
do with the built-in functions
>> The functions have been moved into Excel as native functions in this
>> release.
>
>
> Not all of them have. The vast majority are AWOL.
>

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, Northern Territory, Australia
+61 4 1209 1410, mailto:john@mcghie.name
 >> Stay informed about: Where are the add-ins in Office 2008? 

Given -- <br>
"Our resident Excel Expert, JE McGimpsey has challenged people to identify an analysis you can't do with the built-in functions in E2008 " <br><br>then how does one implement a multivariate regression in Excel? For example, projected home value based on neighborhood, square footage, property taxes, bedrooms, bathrooms, pool, etc.
 >> Stay informed about: Where are the add-ins in Office 2008? 

In article <ee88e1d.9 DeleteThis @webcrossing.caR9absDaxw>, "Stumped in NYC" <>
wrote:

> Given -- <br>
> "Our resident Excel Expert, JE McGimpsey has challenged people to identify an
> analysis you can't do with the built-in functions in E2008 " <br><br>then how
> does one implement a multivariate regression in Excel? For example, projected
> home value based on neighborhood, square footage, property taxes, bedrooms,
> bathrooms, pool, etc.

Stumped -

It's been a long while since I did a multivariate regression, but IIRC,
the ATP just does a linear regression using the standard matrix method
found in any statistics textbook, which would find the coefficients
something like:

= MMULT(MINVERSE(MMULT(TRANSPOSE(X),X)),MMULT(TRANSPOSE(X),Y))

array entered into a column with the same number of rows that X has
columns, where

X = columns of independent variables
Y = column of knowns
 >> Stay informed about: Where are the add-ins in Office 2008? 

In article <jemcgimpsey-43786C.22531321012008 DeleteThis @news.microsoft.com>,
JE McGimpsey <jemcgimpsey DeleteThis @mvps.org> wrote:

> Stumped -
>
> It's been a long while since I did a multivariate regression, but IIRC,
> the ATP just does a linear regression using the standard matrix method
> found in any statistics textbook, which would find the coefficients
> something like:
>
> = MMULT(MINVERSE(MMULT(TRANSPOSE(X),X)),MMULT(TRANSPOSE(X),Y))
>
> array entered into a column with the same number of rows that X has
> columns, where
>
> X = columns of independent variables
> Y = column of knowns

One note: to get the intercept, one column in X needs to be all 1's
 >> Stay informed about: Where are the add-ins in Office 2008? 

Gee Nick - I don't see where anyone even remotely suggested that it was an
*improvement* - just that that's how it is:-) Nobody here has any control
over MS decision making & the loss of VBA has been a devastating blow to
many of those who regularly participate in this group - people who rely on
Excel to make their living.

If you're genuinely concerned you might try using the Help> Send Feedback to
submit a convincing argument to MS on the issue. All we can do here is offer
support on what the software *does* have to offer.

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 1/29/08 10:34 PM, in article ee88e1d.12.TakeThisOut@webcrossing.caR9absDaxw, "nick
whittle " <> wrote:

> So you're telling me that the lovely little 'descriptive statistics' table one
> could generate in the stats tool pack is no longer available, and that if I
> want something like that I have to punch in each function individually? How is
> that an improvement?
 >> Stay informed about: Where are the add-ins in Office 2008? 

In article <ee88e1d.12.RemoveThis@webcrossing.caR9absDaxw>, "nick whittle" <>
wrote:

> So you're telling me that the lovely little 'descriptive statistics' table
> one could generate in the stats tool pack is no longer available, and that if
> I want something like that I have to punch in each function individually?

Yes. No - take a look here:

http://www.coventry.ac.uk/ec/~nhunt/oatbran/

> How is that an improvement?

Nobody has said that it's an improvement. Simply a consequence of not
having the resources to implement VBA in Office 2008.
 >> Stay informed about: Where are the add-ins in Office 2008? 

On 3/5/08 6:55 PM, in article ee88e1d.15.DeleteThis@webcrossing.caR9absDaxw, "Concern"
<Concern> wrote:

> When will the VBA in office 2008 become and update or plug in? Is this
> something that they will correct.

Doubtful. It was removed and don't expect to see it back unless there is
some miracle. Many users are keeping 2004 around just for VBA.

--
Diane, Microsoft Mac MVP (MVPs are not Microsoft Employees)
Entourage Help Page <http://www.entourage.mvps.org/>
Entourage Help Blog <http://blog.entourage.mvps.org/>
 >> Stay informed about: Where are the add-ins in Office 2008? 

The "Official" answers are:

1) Never

2) No

If you do not like those answers, you should use "Send Feedback" from the
Help menu to tell Microsoft what you want it for, and why AppleScript won't
do what you want.

Microsoft announced that VBA was being removed from Office 2007 for the PC
also. After a large amount of customer pressure, they changed their minds.

This would be possible in Mac Office too. Any decision can be changed.

But the price tag of changing this particular decision is a few million
dollars. Can you help us demonstrate to Microsoft that it will make a few
million dollars extra profit if it changes its mind on this?

Because that's the key to it. Remember, the designers and coders working at
Microsoft Macintosh Business Unit do what they are told. Microsoft has this
magic "Do what you're told or get fired" incentive policy common in a lot of
large companies around the globe :-)

And that applies to everyone, up to and including Steve Ballmer/Bill Gates.

The people doing the "telling" are the Board of Directors. Basically: your
pension fund and mine.

How are you going to convince your pension fund to ask Microsoft to change
its decision on VBA? It can be done. It has been done: in Office 2007.
How are we going to do this on the Mac?

Hope this helps


On 6/3/08 1:55 PM, in article ee88e1d.15.RemoveThis@webcrossing.caR9absDaxw, "Concern"
<Concern> wrote:

> When will the VBA in office 2008 become and update or plug in? Is this
> something that they will correct.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50
+61 4 1209 1410, mailto:john@mcghie.name
 >> Stay informed about: Where are the add-ins in Office 2008?