Hi All,

Several years ago I created a company purchase order generation app
using Excel97-VBA. My programming background was from the days of
Cobal so this was an arduous project for me requiring LOTS of input
from this group and other web resources. Obviously Excel97 is very
old in the tooth so I'm considering upgrading and am curious about the
issues I face. Two questions come to mind...

1. Will the program written with Excel97-VBA work with Excel 2003 and/
or Excel 2007?

2. I understand Excel 2007 is significantly different which concerns
me as about half of my users are older and technically impaired.
Opinions on whether to upgrade to Excel 2003 (while I can still get
it) or Excel 2007 would be welcome. Company PC's are all running XP
Pro with no plans to upgrade to Vista in the immediate future.

TIA

--
Brian Fluet

xl2007 contains the new ribbon interface vice the old menus. Your users
might need training just to use it effectively.

Beyond that, "cobol" style data processing statements should work fine.
Useforms should work. custom menus would require attention.

Try downloading an evaluation copy of xl2007 and installing it on a test
machine. then try your app on that.

Others may have additional thoughts.

--
Regards,
Tom Ogilvy


"BrianG" wrote:

Hi All,

Several years ago I created a company purchase order generation app
using Excel97-VBA. My programming background was from the days of
Cobal so this was an arduous project for me requiring LOTS of input
from this group and other web resources. Obviously Excel97 is very
old in the tooth so I'm considering upgrading and am curious about the
issues I face. Two questions come to mind...

1. Will the program written with Excel97-VBA work with Excel 2003 and/
or Excel 2007?

2. I understand Excel 2007 is significantly different which concerns
me as about half of my users are older and technically impaired.
Opinions on whether to upgrade to Excel 2003 (while I can still get
it) or Excel 2007 would be welcome. Company PC's are all running XP
Pro with no plans to upgrade to Vista in the immediate future.

TIA

--
Brian Fluet