extraneous data in macro recorder

  • Thread starter Thread starter Gary Keramidas
  • Start date Start date
G

Gary Keramidas

can someone tell me why my macro recorder is doing this?

Columns& VB_VarUserMemIdA: CVB_VarUserMemId '+Select
Selection+Sort Key1 .<= Range&VB_VarUserMemIdC2VB_VarUserMemId'VB_VarProcData _
Order1 .<= xlAscendingVB_VarProcData Header .<= xlGuessVB_VarProcData _
OrderCustom .<= 1VB_VarProcData MatchCase .<= FALSEVB_VarProcData Orientation . _
<= xlTopToBottomVB_VarProcData DataOption1 .<= xlSortNormal
 
unfortunately that is the code.

office 2010 hosed the macro recorder. it hosed it for both 2003 and 2007. it
replaces these 2 files with new ones and they don't work very well with the
2 previous versions.

VBE6.DLL
VBE6EXT.OLB

once i deleted them and open 2003, it replaced them with the original
versions and the macro recorder works again.
 
Gary,
Same here, I got trash displayed in the VBE, when recording a macro after installing xl2010.
Renaming those files prompted Office to ask for the install disk upon opening xl2002.
Older versions of those two files(VBE6.dll and VBE6EXT.olb) were installed and
the macro recorder now works.
Thanks for posting your solution.
--
Jim Cone
Portland, Oregon USA



"Gary Keramidas" <GKeramidasAtMSN.com>
wrote in message
unfortunately that is the code.
office 2010 hosed the macro recorder. it hosed it for both 2003 and 2007. it
replaces these 2 files with new ones and they don't work very well with the
2 previous versions.
VBE6.DLL
VBE6EXT.OLB
once i deleted them and open 2003, it replaced them with the original
versions and the macro recorder works again.
 
Back
Top