me.pictures.visible

**kingsolo** · 01-12-2007, 11:48 PM

Is there a limit on the amout of pictures you can use with the statement me.pictures.visible? Reason being, I am trying to import 119 pictures into a spreadsheet. When the information is selected form a drop down list, it pulls up the 1 of the 119 pictures. I was able to get 54 pictures input. Everything was going great until the 55th. When it stared giving me an error...
______________________________________________
Runtime Error '1004':

Unable to set the Visible property of the Pictures class
______________________________________________

When I select Debug, it takes me to the line with Me.Pictures.Visible = False

Everything seems to work fine until I enter the 55th picture. If it is that, is there a viable work around?

Thanks.

**raypayette** · 01-13-2007, 04:12 AM

Excel was primarily designed as a spreadsheet. Perhars you could have a link to another software like IrfanView that has a thumbnail display.

**kingsolo** · 01-13-2007, 09:40 AM

Does Irfan View package well with excel, or would people who use the spreadsheet I am making need to have Irfan View as well?

**kingsolo** · 01-13-2007, 12:25 PM

Okay, I took and placed my formula into a different workbook and it goes over 55 pictures. Any clues as to what might be causing this? I even deleted one of my source pictures from the page that I am staging them on before I move them onto my display sheet (I am using the McG & Associates formula) but it's still giving me the error.

Any & all help appreciated.

**VBA Noob** · 01-13-2007, 01:07 PM

Hi,

I seen other posts suggesting that there is a limit. I think the limit depends on the size of the pictures

VBA Noob

**kingsolo** · 01-13-2007, 01:46 PM

I tell ya, that's just how my luck is going with this project!

Oh well, back to the drawing board.

**raypayette** · 01-13-2007, 03:33 PM

I don't know why you are mad! Of course there are limits! Perhaps the limits is the virtual memory on your computer?
Excel is a very powerful spreadsheet tool but it can't do everything you can think of. Putting 55 pictures in one spreadsheet is a feat in itself when you think of it; compare it to a few years ago when it was limited to 64Ks.
Perhaps you should use a database or other tools. Good luck.

**kingsolo** · 01-13-2007, 03:43 PM

It's just one thing after another with this project. I am trying to learn as I go, and this place has been a wealth of knowledge and help when I hit my blocks. With this one in particular, it has been a bear. I'm sure you have had these moments too. I'm not mad as much as frustrated cause everything seemed to be going right them it all blew up.

**Bryan Hessey** · 01-14-2007, 07:29 AM

Originally Posted by kingsolo

It's just one thing after another with this project. I am trying to learn as I go, and this place has been a wealth of knowledge and help when I hit my blocks. With this one in particular, it has been a bear. I'm sure you have had these moments too. I'm not mad as much as frustrated cause everything seemed to be going right them it all blew up.

Hi,

You are really not doing well with this project.

The Pictures from your previous post would work, but require very careful control over names used, however, that my sample still works shows the idea posted by VBA Noob can work.

Another alternate is that http://www.parry.co.nz/wc.zip shows what can be done with pics such as you are trying to do, and Graham Paramore's site states that he is 'Parrry' on several Excel forums, and whilst he would not give full details as to the code used in the WC he might, if you explain what you are trying to do, be tempted to answer whether regular pictures (scaled by Excel) or Thumbnails (and how to etc) were used.

(Just a thought)
---

**kingsolo** · 01-14-2007, 11:56 AM

I think I am just going to back burner the picture thing for now... I will revisit it once my skills have grown with excel. Who knows, Microsoft may increase the picture control in the next version. For now though, I have come up with something else and will go with that. It does the same thing, just not as flashy & pretty. I will see if I can locate Parrry on some Excel forums and see if he can answer some of my questions about working with pictures in excel. Thanks for your help again Bryan.

me.pictures.visible

LinkBack

Thread Tools

Rate This Thread

Display

me.pictures.visible

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions