Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code to delete duplicate and extraneous data | Excel Programming | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Import data using macro recorder | Excel Programming | |||
MACRO RECORDER | Excel Programming |