Original post or original poster.

Frank wrote:

Peter,

Can you tell me what OP stands for? Other Party?

"Peter T" wrote:

Ryan, not sure how that advice will help the OP. From what he is saying his
macro recorder works correctly in 2003 but not in 2007. That's particularly
the case with shapes and charts though in this particular case it's not
obvious why it's not working correctly. However, anyone wanting to write VBA
is strongly advised to retain 2003 for the macro recorder alone.

There may be other good reasons too. Several features have been removed in
2007, for example if you need to build a data cube you need to revert to
2003. Of course most developers need to cater for all versions.

Rich, the code you posted does not look like anything the macro recorder
should return, even in 2007.

Regards,
Peter T

"ryguy7272" wrote in message
...
I used to have booth versions of Office too. Then, I had problems like you
describe and decided to get rid of 2003. Why do you need old technology?
2007 will do everything that 2003 does, and a whole lot more too.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Rich" wrote:

I have Office 2003 AND Office 2007 installed on my PC.

Now, when I record a keystroke macro to put some text into a cell and hit
enter, then go to the VBA Editor, the resultant macro is not what I'm
used to
seeing. For instance to record putting some garbage in Cell a1, I get the
following:

ActiveCell FormulaR1C1 <= VB_VarUserMemIdasdfasdfVB_VarUserMemId
Range& VB_VarUserMemIdA3VB_VarUserMemId '+Select

When I attempt to run it, I receive a "Compile error: Invalid use of
peropery".

What do I need to change?

Thanks for any help.


.


--

Dave Peterson