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?)

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.

--
Biff
Microsoft Excel MVP


"Kevryl" wrote in message
...
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?)

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

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

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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.

--
Biff
Microsoft Excel MVP


"Kevryl" wrote in message
...
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?)

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.

"T. Valko" wrote:

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

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

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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.

--
Biff
Microsoft Excel MVP


"Kevryl" wrote in message
...
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?)




.

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.


--


Gary Keramidas
Excel 2003


"T. Valko" wrote in message
...
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.

--
Biff
Microsoft Excel MVP


"Kevryl" wrote in message
...
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?)

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" wrote:

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.


--


Gary Keramidas
Excel 2003


"T. Valko" wrote in message
...
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.

--
Biff
Microsoft Excel MVP


"Kevryl" wrote in message
...
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?)



.

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

http://office2010.microsoft.com/en-u...4.aspx?redir=0

--


Gary Keramidas
Excel 2003


"Kevryl" wrote in message
...
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" wrote:

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.


--


Gary Keramidas
Excel 2003


"T. Valko" wrote in message
...
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.

--
Biff
Microsoft Excel MVP


"Kevryl" wrote in message
...
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?)



.

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

"Gary Keramidas" wrote:

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

http://office2010.microsoft.com/en-u...4.aspx?redir=0

--


Gary Keramidas
Excel 2003


"Kevryl" wrote in message
...
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" wrote:

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.


--


Gary Keramidas
Excel 2003


"T. Valko" wrote in message
...
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.

--
Biff
Microsoft Excel MVP


"Kevryl" wrote in message
...
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?)



.


.