I tell ya, that's just how my luck is going with this project!Oh well, back to the drawing board.
I tell ya, that's just how my luck is going with this project!Oh well, back to the drawing board.
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.
Best regards,
Ray
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,Originally Posted by kingsolo
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)
---
Si fractum non sit, noli id reficere.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks