2000 - 2007: gotchas?
Gord Dibben wrote:
On Wed, 14 Dec 2011 14:39:19 -0800, "joeu2004"
wrote:
"Auric__" wrote:
I've acquired a copy of Office 2007. Up to now, I've
been using Office 2000. As far as VBA goes, are there
any major "gotchas" I need to be aware of? Or should
my 2000 code "just work" under 2007?
Although you seem to be interested in __program__ incompatibility, I
want to forewarn you of a __programming__ (i.e. usage)
"incompatibility".
Bottom line: Do not get rid of your copy of Excel 2000. Instead,
custom install Office 2007 so that you can retain Office 2000.
I am fortunate to have done that when I installed Office 2010 on a
system that had (still has) Office 2003.
I discovered that the F1 help information in Excel 2010 VBA is nowhere
near as good as Excel 2003 VBA. Fortunately, I still have the latter to
go back when I need help.
I don't know if the same can be said of Excel 2000 VBA v. Excel 2007
VBA. But you might be sorry if you assume otherwise.
At a minimum find and save all the 2000 version VBA???.chm files.
You can d-click to open them when you really need help.
Is there *that* little info in the 2007 helpfiles to warrant it?
Or...........if brave enough...............rename the 2007 *.chm files
Back them up first.
I've got 2000 on my server's Windows install; I can copy them over if-and-
when.
--
Many can understand.
What people do with understanding is another matter.
|