Problem With Recording a Macro in Excel 2007
 

I am in the process of trying to write a macro that includes inserting
pictures on the spreadsheet in a specific place with a specific size
depending upon specific things happening. I tried recording a macro in Excel
2007 to start the ball rolling, but it won't record anything to do with the
pictures. I went back to Excel 2003 and did it successfully, and then copied
the macro over to 2007 and it ran fine. What the heck? Does anybody know if
this is an inherent problem with Excel 2007? What's going on?

Thank you

Problem With Recording a Macro in Excel 2007
 

The shape's and some of the chart's infrastructure has been rebuilt in 2007
and the macro recorder wasn't updated with the changes. This is a known and
inconvenient issue, but at least those of us who still have older versions
of Excel can use the older recorders. PowerPoint 2007 lost its recorder
completely.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob" wrote in message
...
I am in the process of trying to write a macro that includes inserting
pictures on the spreadsheet in a specific place with a specific size
depending upon specific things happening. I tried recording a macro in
Excel
2007 to start the ball rolling, but it won't record anything to do with
the
pictures. I went back to Excel 2003 and did it successfully, and then
copied
the macro over to 2007 and it ran fine. What the heck? Does anybody know
if
this is an inherent problem with Excel 2007? What's going on?

Thank you

Problem With Recording a Macro in Excel 2007
 

Thanks for the update Jon. Any clue when Microsoft will "make things right"?



"Jon Peltier" wrote:

The shape's and some of the chart's infrastructure has been rebuilt in 2007
and the macro recorder wasn't updated with the changes. This is a known and
inconvenient issue, but at least those of us who still have older versions
of Excel can use the older recorders. PowerPoint 2007 lost its recorder
completely.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob" wrote in message
...
I am in the process of trying to write a macro that includes inserting
pictures on the spreadsheet in a specific place with a specific size
depending upon specific things happening. I tried recording a macro in
Excel
2007 to start the ball rolling, but it won't record anything to do with
the
pictures. I went back to Excel 2003 and did it successfully, and then
copied
the macro over to 2007 and it ran fine. What the heck? Does anybody know
if
this is an inherent problem with Excel 2007? What's going on?

Thank you

Problem With Recording a Macro in Excel 2007
 

Hopefully in the next version of Office. I don't expect they'll bother
including this in a service pack.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob" wrote in message
...
Thanks for the update Jon. Any clue when Microsoft will "make things
right"?



"Jon Peltier" wrote:

The shape's and some of the chart's infrastructure has been rebuilt in
2007
and the macro recorder wasn't updated with the changes. This is a known
and
inconvenient issue, but at least those of us who still have older
versions
of Excel can use the older recorders. PowerPoint 2007 lost its recorder
completely.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Bob" wrote in message
...
I am in the process of trying to write a macro that includes inserting
pictures on the spreadsheet in a specific place with a specific size
depending upon specific things happening. I tried recording a macro in
Excel
2007 to start the ball rolling, but it won't record anything to do with
the
pictures. I went back to Excel 2003 and did it successfully, and then
copied
the macro over to 2007 and it ran fine. What the heck? Does anybody
know
if
this is an inherent problem with Excel 2007? What's going on?

Thank you