extraneous data in macro recorder

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
 
S

stanleydgromjr

Gary Keramidas,

Please post your code again using code tags.

At the beginning of your posted code, *enter the following without the
quote marks*:
["code"]


Your code goes here.


At the end of your posted code, *enter the following without the quote
marks*:
["/code"]


Have a great day,
Stan
 
G

Gary Keramidas

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.
 
J

Jim Cone

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.
 
Top