If the pictures weren't too large (in bytes), then I'd just put them all in the
same location--where they need to be to be printed.
Then instead of loading them from the folder, just show the one you want (and
hide the others).
worksheets("somesheetname").pictures("Pict001").visible = true
kind of thing.
Tomas Stroem wrote:
>
> Sorry,
>
> I mean a sheet that loks like a form, feed from the sheet with data, one of
> the pieces of information needed is the picture that I want to insert at a
> specific location in this form sheet.
>
> The user will, through filters, find the set of information suitable for
> what shall be accomplished. In a cell they will enteyr the number for this
> information set, which I will use to populate the form sheet. Then they will
> print the now created sheet to use as instructions in next operation. One of
> the pieces of information is the picture that I need to insert-
>
> The data will be several hundred rows where each row will fill the form
> sheet. -number of pictures i far less, perhaps 20. I will create an
> indentifier to choose picture from depending on three different pieces of
> information in the database. This will be numbers from 1-20. I plan to save
> the pictures in the same directory as the worksheet containing data. Name
> will be "pic 1.jpg" ....
>
> Hope this gives a better idea...
>
> --
> Tomas S
>
> "Rick Rothstein" wrote:
>
> > I think we need some more information. When you say "form", do you mean a
> > UserForm or a worksheet made to look like a form? Are you talking about
> > having several pictures and having them automatically change as the data
> > changes in some way? If so, tell us what the conditions are that determine
> > what pictures to use. Also, to make it easier on you for implementing any
> > code we give you, tell us the names of your picture files, the directory
> > they are kept in and which picture file goes with which data condition.
> >
> > --
> > Rick (MVP - Excel)
> >
> >
> > "Tomas Stroem" <(E-Mail Removed)> wrote in message
> > news:970960A9-4D83-4949-81E8-(E-Mail Removed)...
> > > Hi,
> > >
> > > I am about to make a form from data in an excel sheet, simple, until the
> > > demand came that, depending on some data in this sheet, a specific picture
> > > is
> > > supposed to be dislplayed in the form.
> > >
> > > My guess is that a macro is the best way to make this happen but right now
> > > I
> > > dont see the way, can somebody give an idéa?
> > >
> > > grateful for all suggestions
> > > --
> > > Tomas S
> >
> >
--
Dave Peterson
|
Similar Threads
