I've been given a Word file. It contains an 'image' which is actually a
company logo.
Is there a way to (say) save this to a bitmap file then import it into
Excel?
My aim would be to place this on an Userform (in an
Image?)
Thanks.
I've been given a Word file. It contains an 'image' which is actually a
company logo.
Is there a way to (say) save this to a bitmap file then import it into
Excel?
My aim would be to place this on an Userform (in an
Image?)
Thanks.
This worked ok for me (and avoided saving the picture).
Select the picture in Word
Rightclick|Copy
Back to the Excel Userform.
Insert an Image in your userform
hit F4 to see that image's properties.
Click on Picture
ctrl-v (to paste)
You may be able to copy the picture from MSWord and paste to your favorite
picture editor and save from there, too.
Stuart wrote:
>
> I've been given a Word file. It contains an 'image' which is actually a
> company logo.
>
> Is there a way to (say) save this to a bitmap file then import it into
> Excel?
>
> My aim would be to place this on an Userform (in an
> Image?)
>
> Thanks.
--
Dave Peterson
Many thanks.
The copy/paste works, but it does not appear in the
printed form. If it makes a difference, the Image's
Picture property is showing as a Metafile.
What might I be doing wrong, please?
Regards.
"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:423B54AC.83F13FF@netscapeXSPAM.com...
> This worked ok for me (and avoided saving the picture).
>
> Select the picture in Word
> Rightclick|Copy
>
> Back to the Excel Userform.
> Insert an Image in your userform
> hit F4 to see that image's properties.
> Click on Picture
> ctrl-v (to paste)
>
> You may be able to copy the picture from MSWord and paste to your favorite
> picture editor and save from there, too.
>
> Stuart wrote:
>>
>> I've been given a Word file. It contains an 'image' which is actually a
>> company logo.
>>
>> Is there a way to (say) save this to a bitmap file then import it into
>> Excel?
>>
>> My aim would be to place this on an Userform (in an
>> Image?)
>>
>> Thanks.
>
> --
>
> Dave Peterson
It worked ok for me when I did a me.printform.
A long time ago, we had problems printing too much info on the sheet. We
increased the memory for the printer and we could print ok.
But I don't have a real guess.
Stuart wrote:
>
> Many thanks.
> The copy/paste works, but it does not appear in the
> printed form. If it makes a difference, the Image's
> Picture property is showing as a Metafile.
>
> What might I be doing wrong, please?
>
> Regards.
>
> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> news:423B54AC.83F13FF@netscapeXSPAM.com...
> > This worked ok for me (and avoided saving the picture).
> >
> > Select the picture in Word
> > Rightclick|Copy
> >
> > Back to the Excel Userform.
> > Insert an Image in your userform
> > hit F4 to see that image's properties.
> > Click on Picture
> > ctrl-v (to paste)
> >
> > You may be able to copy the picture from MSWord and paste to your favorite
> > picture editor and save from there, too.
> >
> > Stuart wrote:
> >>
> >> I've been given a Word file. It contains an 'image' which is actually a
> >> company logo.
> >>
> >> Is there a way to (say) save this to a bitmap file then import it into
> >> Excel?
> >>
> >> My aim would be to place this on an Userform (in an
> >> Image?)
> >>
> >> Thanks.
> >
> > --
> >
> > Dave Peterson
--
Dave Peterson
Hmm. Used the PrintForm command from the Immediate
Window with the same result - no image, just the outline
of the image.
Placed the Logo into a standard sheet, highlighted it and looked at the
Formula bar ....... it reports as follows:
=EMBED("Word.Picture.8","")
Does this shed any light, please?
Regards.
"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:423C12AB.3822A307@netscapeXSPAM.com...
> It worked ok for me when I did a me.printform.
>
> A long time ago, we had problems printing too much info on the sheet. We
> increased the memory for the printer and we could print ok.
>
> But I don't have a real guess.
>
> Stuart wrote:
>>
>> Many thanks.
>> The copy/paste works, but it does not appear in the
>> printed form. If it makes a difference, the Image's
>> Picture property is showing as a Metafile.
>>
>> What might I be doing wrong, please?
>>
>> Regards.
>>
>> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
>> news:423B54AC.83F13FF@netscapeXSPAM.com...
>> > This worked ok for me (and avoided saving the picture).
>> >
>> > Select the picture in Word
>> > Rightclick|Copy
>> >
>> > Back to the Excel Userform.
>> > Insert an Image in your userform
>> > hit F4 to see that image's properties.
>> > Click on Picture
>> > ctrl-v (to paste)
>> >
>> > You may be able to copy the picture from MSWord and paste to your
>> > favorite
>> > picture editor and save from there, too.
>> >
>> > Stuart wrote:
>> >>
>> >> I've been given a Word file. It contains an 'image' which is actually
>> >> a
>> >> company logo.
>> >>
>> >> Is there a way to (say) save this to a bitmap file then import it into
>> >> Excel?
>> >>
>> >> My aim would be to place this on an Userform (in an
>> >> Image?)
>> >>
>> >> Thanks.
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson
Not to me.
But I don't think that a picture in an image on a userform would have much in
common with an object placed on the worksheet--but I've been wrong before.
Did you try a smaller picture to see if that was the problem?
Stuart wrote:
>
> Hmm. Used the PrintForm command from the Immediate
> Window with the same result - no image, just the outline
> of the image.
>
> Placed the Logo into a standard sheet, highlighted it and looked at the
> Formula bar ....... it reports as follows:
> =EMBED("Word.Picture.8","")
>
> Does this shed any light, please?
>
> Regards.
>
> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> news:423C12AB.3822A307@netscapeXSPAM.com...
> > It worked ok for me when I did a me.printform.
> >
> > A long time ago, we had problems printing too much info on the sheet. We
> > increased the memory for the printer and we could print ok.
> >
> > But I don't have a real guess.
> >
> > Stuart wrote:
> >>
> >> Many thanks.
> >> The copy/paste works, but it does not appear in the
> >> printed form. If it makes a difference, the Image's
> >> Picture property is showing as a Metafile.
> >>
> >> What might I be doing wrong, please?
> >>
> >> Regards.
> >>
> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> >> news:423B54AC.83F13FF@netscapeXSPAM.com...
> >> > This worked ok for me (and avoided saving the picture).
> >> >
> >> > Select the picture in Word
> >> > Rightclick|Copy
> >> >
> >> > Back to the Excel Userform.
> >> > Insert an Image in your userform
> >> > hit F4 to see that image's properties.
> >> > Click on Picture
> >> > ctrl-v (to paste)
> >> >
> >> > You may be able to copy the picture from MSWord and paste to your
> >> > favorite
> >> > picture editor and save from there, too.
> >> >
> >> > Stuart wrote:
> >> >>
> >> >> I've been given a Word file. It contains an 'image' which is actually
> >> >> a
> >> >> company logo.
> >> >>
> >> >> Is there a way to (say) save this to a bitmap file then import it into
> >> >> Excel?
> >> >>
> >> >> My aim would be to place this on an Userform (in an
> >> >> Image?)
> >> >>
> >> >> Thanks.
> >> >
> >> > --
> >> >
> >> > Dave Peterson
> >
> > --
> >
> > Dave Peterson
--
Dave Peterson
OK, just try what you already stated your self; Copy>Paste the image into
MSPaint and see what you can save it as. Then go back to Excel and Insert
that image into your form.
Seems the simplest way to me, but I'm no MVP or VIP...just lurking.
"Stuart" <sgbooth@totalise.co.uk> wrote in message
news:ObPMeb$KFHA.3380@TK2MSFTNGP10.phx.gbl...
> I've been given a Word file. It contains an 'image' which is actually a
> company logo.
>
> Is there a way to (say) save this to a bitmap file then import it into
> Excel?
>
> My aim would be to place this on an Userform (in an
> Image?)
>
> Thanks.
>
Managed to get the image into a standard sheet. It printed fine from
there......so it's not the size of the picture, nor the printer memory.
Could I reference the image in the sheet in the Form's
Initalise Event? The image is on a sheet in a loaded addin
(the addin contains the form).
Regards.
"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:423C53B8.5AF78409@netscapeXSPAM.com...
> Not to me.
>
> But I don't think that a picture in an image on a userform would have much
> in
> common with an object placed on the worksheet--but I've been wrong before.
>
> Did you try a smaller picture to see if that was the problem?
>
> Stuart wrote:
>>
>> Hmm. Used the PrintForm command from the Immediate
>> Window with the same result - no image, just the outline
>> of the image.
>>
>> Placed the Logo into a standard sheet, highlighted it and looked at the
>> Formula bar ....... it reports as follows:
>> =EMBED("Word.Picture.8","")
>>
>> Does this shed any light, please?
>>
>> Regards.
>>
>> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
>> news:423C12AB.3822A307@netscapeXSPAM.com...
>> > It worked ok for me when I did a me.printform.
>> >
>> > A long time ago, we had problems printing too much info on the sheet.
>> > We
>> > increased the memory for the printer and we could print ok.
>> >
>> > But I don't have a real guess.
>> >
>> > Stuart wrote:
>> >>
>> >> Many thanks.
>> >> The copy/paste works, but it does not appear in the
>> >> printed form. If it makes a difference, the Image's
>> >> Picture property is showing as a Metafile.
>> >>
>> >> What might I be doing wrong, please?
>> >>
>> >> Regards.
>> >>
>> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
>> >> news:423B54AC.83F13FF@netscapeXSPAM.com...
>> >> > This worked ok for me (and avoided saving the picture).
>> >> >
>> >> > Select the picture in Word
>> >> > Rightclick|Copy
>> >> >
>> >> > Back to the Excel Userform.
>> >> > Insert an Image in your userform
>> >> > hit F4 to see that image's properties.
>> >> > Click on Picture
>> >> > ctrl-v (to paste)
>> >> >
>> >> > You may be able to copy the picture from MSWord and paste to your
>> >> > favorite
>> >> > picture editor and save from there, too.
>> >> >
>> >> > Stuart wrote:
>> >> >>
>> >> >> I've been given a Word file. It contains an 'image' which is
>> >> >> actually
>> >> >> a
>> >> >> company logo.
>> >> >>
>> >> >> Is there a way to (say) save this to a bitmap file then import it
>> >> >> into
>> >> >> Excel?
>> >> >>
>> >> >> My aim would be to place this on an Userform (in an
>> >> >> Image?)
>> >> >>
>> >> >> Thanks.
>> >> >
>> >> > --
>> >> >
>> >> > Dave Peterson
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson
I'm confused at how referring to the picture on the sheet will help print the
userform correctly.
Stuart wrote:
>
> Managed to get the image into a standard sheet. It printed fine from
> there......so it's not the size of the picture, nor the printer memory.
> Could I reference the image in the sheet in the Form's
> Initalise Event? The image is on a sheet in a loaded addin
> (the addin contains the form).
>
> Regards.
>
> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> news:423C53B8.5AF78409@netscapeXSPAM.com...
> > Not to me.
> >
> > But I don't think that a picture in an image on a userform would have much
> > in
> > common with an object placed on the worksheet--but I've been wrong before.
> >
> > Did you try a smaller picture to see if that was the problem?
> >
> > Stuart wrote:
> >>
> >> Hmm. Used the PrintForm command from the Immediate
> >> Window with the same result - no image, just the outline
> >> of the image.
> >>
> >> Placed the Logo into a standard sheet, highlighted it and looked at the
> >> Formula bar ....... it reports as follows:
> >> =EMBED("Word.Picture.8","")
> >>
> >> Does this shed any light, please?
> >>
> >> Regards.
> >>
> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> >> news:423C12AB.3822A307@netscapeXSPAM.com...
> >> > It worked ok for me when I did a me.printform.
> >> >
> >> > A long time ago, we had problems printing too much info on the sheet.
> >> > We
> >> > increased the memory for the printer and we could print ok.
> >> >
> >> > But I don't have a real guess.
> >> >
> >> > Stuart wrote:
> >> >>
> >> >> Many thanks.
> >> >> The copy/paste works, but it does not appear in the
> >> >> printed form. If it makes a difference, the Image's
> >> >> Picture property is showing as a Metafile.
> >> >>
> >> >> What might I be doing wrong, please?
> >> >>
> >> >> Regards.
> >> >>
> >> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> >> >> news:423B54AC.83F13FF@netscapeXSPAM.com...
> >> >> > This worked ok for me (and avoided saving the picture).
> >> >> >
> >> >> > Select the picture in Word
> >> >> > Rightclick|Copy
> >> >> >
> >> >> > Back to the Excel Userform.
> >> >> > Insert an Image in your userform
> >> >> > hit F4 to see that image's properties.
> >> >> > Click on Picture
> >> >> > ctrl-v (to paste)
> >> >> >
> >> >> > You may be able to copy the picture from MSWord and paste to your
> >> >> > favorite
> >> >> > picture editor and save from there, too.
> >> >> >
> >> >> > Stuart wrote:
> >> >> >>
> >> >> >> I've been given a Word file. It contains an 'image' which is
> >> >> >> actually
> >> >> >> a
> >> >> >> company logo.
> >> >> >>
> >> >> >> Is there a way to (say) save this to a bitmap file then import it
> >> >> >> into
> >> >> >> Excel?
> >> >> >>
> >> >> >> My aim would be to place this on an Userform (in an
> >> >> >> Image?)
> >> >> >>
> >> >> >> Thanks.
> >> >> >
> >> >> > --
> >> >> >
> >> >> > Dave Peterson
> >> >
> >> > --
> >> >
> >> > Dave Peterson
> >
> > --
> >
> > Dave Peterson
--
Dave Peterson
Yes.. good point.
Say I start from scratch, with an empty Image control
(Image1) on the form (FormMasterFax) and with a picture (Picture 1) in
Sheet1 of the addin.
Just in case I (probably) did something stupid earlier, how
can I place this picture in the form? When I try to set the
Picture property for the Image control it points me to select a file .....
can I refer it to an object on a specific sheet?
Regards.
"Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
news:423D80D8.7CF02682@netscapeXSPAM.com...
> I'm confused at how referring to the picture on the sheet will help print
> the
> userform correctly.
>
>
>
> Stuart wrote:
>>
>> Managed to get the image into a standard sheet. It printed fine from
>> there......so it's not the size of the picture, nor the printer memory.
>> Could I reference the image in the sheet in the Form's
>> Initalise Event? The image is on a sheet in a loaded addin
>> (the addin contains the form).
>>
>> Regards.
>>
>> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
>> news:423C53B8.5AF78409@netscapeXSPAM.com...
>> > Not to me.
>> >
>> > But I don't think that a picture in an image on a userform would have
>> > much
>> > in
>> > common with an object placed on the worksheet--but I've been wrong
>> > before.
>> >
>> > Did you try a smaller picture to see if that was the problem?
>> >
>> > Stuart wrote:
>> >>
>> >> Hmm. Used the PrintForm command from the Immediate
>> >> Window with the same result - no image, just the outline
>> >> of the image.
>> >>
>> >> Placed the Logo into a standard sheet, highlighted it and looked at
>> >> the
>> >> Formula bar ....... it reports as follows:
>> >> =EMBED("Word.Picture.8","")
>> >>
>> >> Does this shed any light, please?
>> >>
>> >> Regards.
>> >>
>> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
>> >> news:423C12AB.3822A307@netscapeXSPAM.com...
>> >> > It worked ok for me when I did a me.printform.
>> >> >
>> >> > A long time ago, we had problems printing too much info on the
>> >> > sheet.
>> >> > We
>> >> > increased the memory for the printer and we could print ok.
>> >> >
>> >> > But I don't have a real guess.
>> >> >
>> >> > Stuart wrote:
>> >> >>
>> >> >> Many thanks.
>> >> >> The copy/paste works, but it does not appear in the
>> >> >> printed form. If it makes a difference, the Image's
>> >> >> Picture property is showing as a Metafile.
>> >> >>
>> >> >> What might I be doing wrong, please?
>> >> >>
>> >> >> Regards.
>> >> >>
>> >> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
>> >> >> news:423B54AC.83F13FF@netscapeXSPAM.com...
>> >> >> > This worked ok for me (and avoided saving the picture).
>> >> >> >
>> >> >> > Select the picture in Word
>> >> >> > Rightclick|Copy
>> >> >> >
>> >> >> > Back to the Excel Userform.
>> >> >> > Insert an Image in your userform
>> >> >> > hit F4 to see that image's properties.
>> >> >> > Click on Picture
>> >> >> > ctrl-v (to paste)
>> >> >> >
>> >> >> > You may be able to copy the picture from MSWord and paste to your
>> >> >> > favorite
>> >> >> > picture editor and save from there, too.
>> >> >> >
>> >> >> > Stuart wrote:
>> >> >> >>
>> >> >> >> I've been given a Word file. It contains an 'image' which is
>> >> >> >> actually
>> >> >> >> a
>> >> >> >> company logo.
>> >> >> >>
>> >> >> >> Is there a way to (say) save this to a bitmap file then import
>> >> >> >> it
>> >> >> >> into
>> >> >> >> Excel?
>> >> >> >>
>> >> >> >> My aim would be to place this on an Userform (in an
>> >> >> >> Image?)
>> >> >> >>
>> >> >> >> Thanks.
>> >> >> >
>> >> >> > --
>> >> >> >
>> >> >> > Dave Peterson
>> >> >
>> >> > --
>> >> >
>> >> > Dave Peterson
>> >
>> > --
>> >
>> > Dave Peterson
>
> --
>
> Dave Peterson
Go to Stephen Bullen's site and get his past picture file:
About 2/3rds the way down on this page:
http://www.oaltd.co.uk/Excel/Default.htm
or a direct link
http://www.oaltd.co.uk/DLCount/DLCou...stePicture.zip
This showns how to take a picture from the clipboard and put it in an image
control.
--
Regards,
Tom Ogilvy
"Stuart" <sgbooth@totalise.co.uk> wrote in message
news:%2324$QzVLFHA.2604@TK2MSFTNGP10.phx.gbl...
> Yes.. good point.
> Say I start from scratch, with an empty Image control
> (Image1) on the form (FormMasterFax) and with a picture (Picture 1) in
> Sheet1 of the addin.
> Just in case I (probably) did something stupid earlier, how
> can I place this picture in the form? When I try to set the
> Picture property for the Image control it points me to select a file .....
> can I refer it to an object on a specific sheet?
>
> Regards.
>
> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> news:423D80D8.7CF02682@netscapeXSPAM.com...
> > I'm confused at how referring to the picture on the sheet will help
> > the
> > userform correctly.
> >
> >
> >
> > Stuart wrote:
> >>
> >> Managed to get the image into a standard sheet. It printed fine from
> >> there......so it's not the size of the picture, nor the printer memory.
> >> Could I reference the image in the sheet in the Form's
> >> Initalise Event? The image is on a sheet in a loaded addin
> >> (the addin contains the form).
> >>
> >> Regards.
> >>
> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> >> news:423C53B8.5AF78409@netscapeXSPAM.com...
> >> > Not to me.
> >> >
> >> > But I don't think that a picture in an image on a userform would have
> >> > much
> >> > in
> >> > common with an object placed on the worksheet--but I've been wrong
> >> > before.
> >> >
> >> > Did you try a smaller picture to see if that was the problem?
> >> >
> >> > Stuart wrote:
> >> >>
> >> >> Hmm. Used the PrintForm command from the Immediate
> >> >> Window with the same result - no image, just the outline
> >> >> of the image.
> >> >>
> >> >> Placed the Logo into a standard sheet, highlighted it and looked at
> >> >> the
> >> >> Formula bar ....... it reports as follows:
> >> >> =EMBED("Word.Picture.8","")
> >> >>
> >> >> Does this shed any light, please?
> >> >>
> >> >> Regards.
> >> >>
> >> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> >> >> news:423C12AB.3822A307@netscapeXSPAM.com...
> >> >> > It worked ok for me when I did a me.printform.
> >> >> >
> >> >> > A long time ago, we had problems printing too much info on the
> >> >> > sheet.
> >> >> > We
> >> >> > increased the memory for the printer and we could print ok.
> >> >> >
> >> >> > But I don't have a real guess.
> >> >> >
> >> >> > Stuart wrote:
> >> >> >>
> >> >> >> Many thanks.
> >> >> >> The copy/paste works, but it does not appear in the
> >> >> >> printed form. If it makes a difference, the Image's
> >> >> >> Picture property is showing as a Metafile.
> >> >> >>
> >> >> >> What might I be doing wrong, please?
> >> >> >>
> >> >> >> Regards.
> >> >> >>
> >> >> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
> >> >> >> news:423B54AC.83F13FF@netscapeXSPAM.com...
> >> >> >> > This worked ok for me (and avoided saving the picture).
> >> >> >> >
> >> >> >> > Select the picture in Word
> >> >> >> > Rightclick|Copy
> >> >> >> >
> >> >> >> > Back to the Excel Userform.
> >> >> >> > Insert an Image in your userform
> >> >> >> > hit F4 to see that image's properties.
> >> >> >> > Click on Picture
> >> >> >> > ctrl-v (to paste)
> >> >> >> >
> >> >> >> > You may be able to copy the picture from MSWord and paste to
your
> >> >> >> > favorite
> >> >> >> > picture editor and save from there, too.
> >> >> >> >
> >> >> >> > Stuart wrote:
> >> >> >> >>
> >> >> >> >> I've been given a Word file. It contains an 'image' which is
> >> >> >> >> actually
> >> >> >> >> a
> >> >> >> >> company logo.
> >> >> >> >>
> >> >> >> >> Is there a way to (say) save this to a bitmap file then import
> >> >> >> >> it
> >> >> >> >> into
> >> >> >> >> Excel?
> >> >> >> >>
> >> >> >> >> My aim would be to place this on an Userform (in an
> >> >> >> >> Image?)
> >> >> >> >>
> >> >> >> >> Thanks.
> >> >> >> >
> >> >> >> > --
> >> >> >> >
> >> >> >> > Dave Peterson
> >> >> >
> >> >> > --
> >> >> >
> >> >> > Dave Peterson
> >> >
> >> > --
> >> >
> >> > Dave Peterson
> >
> > --
> >
> > Dave Peterson
>
>
That worked. Many thanks.
Regards.
"Tom Ogilvy" <twogilvy@msn.com> wrote in message
news:OeYXkCXLFHA.1884@TK2MSFTNGP15.phx.gbl...
> Go to Stephen Bullen's site and get his past picture file:
>
> About 2/3rds the way down on this page:
> http://www.oaltd.co.uk/Excel/Default.htm
>
> or a direct link
>
> http://www.oaltd.co.uk/DLCount/DLCou...stePicture.zip
>
> This showns how to take a picture from the clipboard and put it in an
> image
> control.
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "Stuart" <sgbooth@totalise.co.uk> wrote in message
> news:%2324$QzVLFHA.2604@TK2MSFTNGP10.phx.gbl...
>> Yes.. good point.
>> Say I start from scratch, with an empty Image control
>> (Image1) on the form (FormMasterFax) and with a picture (Picture 1) in
>> Sheet1 of the addin.
>> Just in case I (probably) did something stupid earlier, how
>> can I place this picture in the form? When I try to set the
>> Picture property for the Image control it points me to select a file
>> .....
>> can I refer it to an object on a specific sheet?
>>
>> Regards.
>>
>> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
>> news:423D80D8.7CF02682@netscapeXSPAM.com...
>> > I'm confused at how referring to the picture on the sheet will help
>> > the
>> > userform correctly.
>> >
>> >
>> >
>> > Stuart wrote:
>> >>
>> >> Managed to get the image into a standard sheet. It printed fine from
>> >> there......so it's not the size of the picture, nor the printer
>> >> memory.
>> >> Could I reference the image in the sheet in the Form's
>> >> Initalise Event? The image is on a sheet in a loaded addin
>> >> (the addin contains the form).
>> >>
>> >> Regards.
>> >>
>> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
>> >> news:423C53B8.5AF78409@netscapeXSPAM.com...
>> >> > Not to me.
>> >> >
>> >> > But I don't think that a picture in an image on a userform would
>> >> > have
>> >> > much
>> >> > in
>> >> > common with an object placed on the worksheet--but I've been wrong
>> >> > before.
>> >> >
>> >> > Did you try a smaller picture to see if that was the problem?
>> >> >
>> >> > Stuart wrote:
>> >> >>
>> >> >> Hmm. Used the PrintForm command from the Immediate
>> >> >> Window with the same result - no image, just the outline
>> >> >> of the image.
>> >> >>
>> >> >> Placed the Logo into a standard sheet, highlighted it and looked at
>> >> >> the
>> >> >> Formula bar ....... it reports as follows:
>> >> >> =EMBED("Word.Picture.8","")
>> >> >>
>> >> >> Does this shed any light, please?
>> >> >>
>> >> >> Regards.
>> >> >>
>> >> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
>> >> >> news:423C12AB.3822A307@netscapeXSPAM.com...
>> >> >> > It worked ok for me when I did a me.printform.
>> >> >> >
>> >> >> > A long time ago, we had problems printing too much info on the
>> >> >> > sheet.
>> >> >> > We
>> >> >> > increased the memory for the printer and we could print ok.
>> >> >> >
>> >> >> > But I don't have a real guess.
>> >> >> >
>> >> >> > Stuart wrote:
>> >> >> >>
>> >> >> >> Many thanks.
>> >> >> >> The copy/paste works, but it does not appear in the
>> >> >> >> printed form. If it makes a difference, the Image's
>> >> >> >> Picture property is showing as a Metafile.
>> >> >> >>
>> >> >> >> What might I be doing wrong, please?
>> >> >> >>
>> >> >> >> Regards.
>> >> >> >>
>> >> >> >> "Dave Peterson" <ec35720@netscapeXSPAM.com> wrote in message
>> >> >> >> news:423B54AC.83F13FF@netscapeXSPAM.com...
>> >> >> >> > This worked ok for me (and avoided saving the picture).
>> >> >> >> >
>> >> >> >> > Select the picture in Word
>> >> >> >> > Rightclick|Copy
>> >> >> >> >
>> >> >> >> > Back to the Excel Userform.
>> >> >> >> > Insert an Image in your userform
>> >> >> >> > hit F4 to see that image's properties.
>> >> >> >> > Click on Picture
>> >> >> >> > ctrl-v (to paste)
>> >> >> >> >
>> >> >> >> > You may be able to copy the picture from MSWord and paste to
> your
>> >> >> >> > favorite
>> >> >> >> > picture editor and save from there, too.
>> >> >> >> >
>> >> >> >> > Stuart wrote:
>> >> >> >> >>
>> >> >> >> >> I've been given a Word file. It contains an 'image' which is
>> >> >> >> >> actually
>> >> >> >> >> a
>> >> >> >> >> company logo.
>> >> >> >> >>
>> >> >> >> >> Is there a way to (say) save this to a bitmap file then
>> >> >> >> >> import
>> >> >> >> >> it
>> >> >> >> >> into
>> >> >> >> >> Excel?
>> >> >> >> >>
>> >> >> >> >> My aim would be to place this on an Userform (in an
>> >> >> >> >> Image?)
>> >> >> >> >>
>> >> >> >> >> Thanks.
>> >> >> >> >
>> >> >> >> > --
>> >> >> >> >
>> >> >> >> > Dave Peterson
>> >> >> >
>> >> >> > --
>> >> >> >
>> >> >> > Dave Peterson
>> >> >
>> >> > --
>> >> >
>> >> > Dave Peterson
>> >
>> > --
>> >
>> > Dave Peterson
>>
>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks