Excel 4 macro support--how long?

  • Thread starter Thread starter 123098ajc
  • Start date Start date
1

123098ajc

Hello, I'm looking for information on how much longer MS is going
support Excel 4 macros in subsequent versions of Excel. Does anyone
have any info on this to share?

Thanks in advance,
Michael
 
Anything you get will be pure speculation. I suspect it will be around for
one more release at most as it hasn't now been the 'preferred' macro code
for some 12 years.

They will need to fix some of the issues with VBA before this though, for
example, the slowness of pagesetup in VBA against the Excel 4 macro code

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Nick Hodge wrote...
Anything you get will be pure speculation. I suspect it will be
around for one more release at most as it hasn't now been the
'preferred' macro code for some 12 years.
Click to expand...
...

There may not be many macros written using XLM, but there may be more
than a few VBA procedures that call Application objects'
ExecuteExcel4Macro method. There may also be lots of defined names that
call the XLM functions GET.CELL, GET.DOCUMENT and GET.FORMULA. Some of
these could be replaced with udfs, but it'd be a big chore.
 
John

mmm......good point ;-)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top