"Robert Baer" wrote in message

Note that VBA6 is used up to v2007; beginning with v2010 VBA7 is used
for all (x86/x64) editions of MSO.

FWIW
Also, beginning with v2007 Office you can generate PDFs directly using
SaveAs FixedFormat and choose XPS or PDF.

USEFUL info; Thanks.
Again, un-documented change(s) that wannabe users have to guess at.
M$ s SUCH a piece..

Not trying to defend MS but I don't follow why you regard the above as
'undocumented changes . . . users have to guess at'.

Before each new version the Excel team announce and discuss most planned
changes. On release a full list of changes, new features and any decremented
methods, is published on relevant MS sites and widely mirrored and discussed
elsewhere.

SaveAs PDF or XPS is hard to miss in Excel 2007 when you look at File /
SaveAs

The introduction of 64bit Office has been since its inception and continues
to be one of the most widely discussed and documented changes by MS and
elsewhere. That said if you only ever use 32bit Excel you don't need to know
anything about it. VBA7 can cater for a few special 64bit requirements
should you need them, mainly for use with APIs. Otherwise VBA7 is
effectively VBA6 even in 64bit Excel.

Peter T