Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Recording Macros In Excel 2007


  • Please log in to reply
4 replies to this topic

#1 IrishLefty

IrishLefty

  • Members
  • 24 posts
  • OFFLINE
  •  
  • Local time:08:30 PM

Posted 26 April 2008 - 10:37 AM

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

BC AdBot (Login to Remove)

 


m

#2 jazzman831

jazzman831

  • Members
  • 40 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:12:30 AM

Posted 26 April 2008 - 06:08 PM

What are you trying to do, exactly?
here =/= hear
their =/= there =/= they're
quiet =/= quite
Newegg commenters can't speel! :)

#3 IrishLefty

IrishLefty
  • Topic Starter

  • Members
  • 24 posts
  • OFFLINE
  •  
  • Local time:08:30 PM

Posted 26 April 2008 - 08:59 PM

I'm trying to help a friend develop an estimating program for his business. He only has Excel 2007. The area of concern is that Excel 2007 seems to have a problem with macros. There is no problem in this area with Excel 2003, but Excel 2007 will not record actions involving insertion of pictures and graphs and maybe other things. It does record the insertion of objects (at least a bitmap) without a problem. Have you experienced any problems in this area? If so, have you been able to resolve them? If you have, will you share the solutions?

Thank you

#4 jazzman831

jazzman831

  • Members
  • 40 posts
  • OFFLINE
  •  
  • Gender:Male
  • Local time:12:30 AM

Posted 27 April 2008 - 10:11 AM

Oh man that's horrible. It looks like if you insert a picture or a graph it just plain doesn't record it into the macro!! If you manually type (or copy/paste) the code then it works how it should.

I'm normally a defender of Microsoft's newest editions but there is simply no excuse for this. They took away features that worked perfectly fine in the old version. The worst part is, the bottom 90% of users won't know this; it's only the power users who are being crippled for no apparent reason. Why, Microsoft? Why?

Uggggggggh after I take a couple quick breaths I'll do some searches and see if I can find a fix that doesn't involve uninstalling 2007...
here =/= hear
their =/= there =/= they're
quiet =/= quite
Newegg commenters can't speel! :)

#5 IrishLefty

IrishLefty
  • Topic Starter

  • Members
  • 24 posts
  • OFFLINE
  •  
  • Local time:08:30 PM

Posted 27 April 2008 - 09:38 PM

Well jazzman, you're right. Microsoft screwed this up big time. If you do a Google on "Excel 2007 Problems" you will see a lot more than what I brought up. The only solution for me on this is to use Excel 2003, make all the macros I need, and then copy them over into Excel 2007. A problem with this is that some of them may not work because of more changes in 2007 that I don't know about. Oh well, live and learn.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users