Considering upgrade office 2000 to 2007

[Kevryl]

I just upgraded kicking and screaming to Windows 7 (love it) and am
considering an upgrade to Office 2007. I use Excel extensively and my 2 main
files are around 20meg each with a large number of quite complex macros.

Any advisory comments would be appreciated, and I'm particularly wondering
about forward compatibility and whether my Excel 2000 macros are likely to
fall over under 2007.

(Also, I'm wondering if the facility has yet been built in to cells to
instruct the cursor on entering to then move to a designated cell?)

 

[T. Valko]

Have you seen or used Excel 2007?

It's quite different in appearnace from any previous versions!

Do any of your macros interact with the Excel user interface? If so, that
could be a big problem in Excel 2007. The developers of Excel 2007 didn't
want anyone to mess with the user interface so they made it very difficult
to do, if not almost impossible in some cases.

The best thing you could do is to download a trial version of Excel 2007 and
take it for a test drive! Excel 2010 will be coming out soon (no, I don't
have any inside info!) so you might want to consider waiting for the newest
version.

 

[T. Valko]

Do any of your macros interact with the Excel user interface?

Meaning: create custom toolbars? Add custom menus or custom menu items? And
such...

 

[Gary Keramidas]

excel 2010 is available to businesses in may, and widely available in june.
if you purchase office 2007 between now the end of september and activate by
the end of september, you can download a free upgrade to office 2010.

excel 2010 is a lot faster than 2007, and even faster than 2003 in places.
in office 2010, you can customize the ribbon, which helps immensely, though
i'm still no fan of it.

but is 2010 better than 2007? by leaps and bounds.

 

[Kevryl]

Thanks Biff, no, no custom toolbars. They do move the cursor (as recorded)
and go to range names, copy, paste and so on. There's some filtering based on
cell contents, posting of results from 1 worksheet to another, print ranges -
that kind of stuff.

I'm not into VB except for some very basic editing of macros. So when I say
"complex" I'm not talking on a programming level - more of number of actions
and length of procedures which do run into several pages when printed off.

I think I'll install the trial package. 60 days does seem a fair deal. I
think you can generally opt to keep existing versions so I guess its safe to
do.

 

[Kevryl]

Thanks, Gary. interesting. I'm in Australia. I wonder if the 2010 upgrade
deal will be global or just U.S.A.? Sometimes software and hardware deals are
not valid outside U.S.

 

[Gary Keramidas]

here's the faq: i had one date wrong, you actually have until october to
request your upgrade

http://office2010.microsoft.com/en-...nology-guarantee-faq-HA101812304.aspx?redir=0

 

[Kevryl]

Thank you Gary. I've checked that out with interest.