extraneous data in macro recorder
 

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_VarProcD ata _
Order1 .<= xlAscendingVB_VarProcData Header .<= xlGuessVB_VarProcData _
OrderCustom .<= 1VB_VarProcData MatchCase .<= FALSEVB_VarProcData Orientation . _
<= xlTopToBottomVB_VarProcData DataOption1 .<= xlSortNormal

--

Gary Keramidas
Excel 2003

extraneous data in macro recorder
 

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


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: http://www.thecodecage.com/forumz/member.php?userid=503
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117584

extraneous data in macro recorder
 

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 Keramidas
Excel 2003


"stanleydgromjr" wrote in message
...

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


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile:
http://www.thecodecage.com/forumz/member.php?userid=503
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=117584

extraneous data in macro recorder
 

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.
--
Gary Keramidas
Excel 2003


"stanleydgromjr" wrote in message
...

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


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile:
http://www.thecodecage.com/forumz/member.php?userid=503
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=117584