Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
Bob Bob is offline
external usenet poster
 
Posts: 972
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default 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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Recording Excel 2007 Abdul[_2_] Excel Programming 6 November 12th 07 12:58 PM
Excel 2007 recording macro Dan[_3_] Excel Discussion (Misc queries) 1 August 16th 07 04:16 PM
Macro Recording 2007 Abdul[_2_] Excel Programming 1 August 15th 07 08:27 AM
Excel 2007 macro recording: objects DMChesser Excel Discussion (Misc queries) 0 July 13th 07 11:04 PM
Excel macro recording problem dg33 Excel Programming 1 August 18th 04 05:01 PM


All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"