"Robert Baer" wrote in message
Peter T wrote:
"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


Excuse me, have NEVER seen any info WRT Excel methods and/or procedures.
For all practical purposes "help" does not exist.

VBA and the Excel object model are exhaustively documented. For help in the
IDE just select a keyword and press F1, typically it'll take you to what
you're looking for. Look through 'Object Browser", and F1 anything for
further help. Plenty on-line too, eg this for Excel 2010 and similar for
other versions.

https://msdn.microsoft.com/en-us/lib...ffice.14).aspx

Furthermore, i gave code where one can PROGRAMATICALLY choose a printer
for the app, and then PROGRAMATICALLY print to it and give print path if
"ON FILE".

I don't follow if you mean something that didn't work for you or a solution
for others, or why it's relevant to anything I mentioned.

SaveAS etc is NOT an option when multiple instances (in a loop) ae
desired.

Why not...?

Peter T