PC Review


Reply
Thread Tools Rate Thread

Where does excel store the pictures of a userform's 'Picture' property?

 
 
zz
Guest
Posts: n/a
 
      19th Jan 2007
it's more an 'existencialist' question than a thecnical one

Where does excel store the pictures of a userform's 'Picture' property?


--
--
---
ZZ [underground]
Semi-musico,cuasi-poeta y loco
 
Reply With Quote
 
 
 
 
zz
Guest
Posts: n/a
 
      19th Jan 2007
:=/

but if i export the userform and import it later in another workbook, it
keeps the property too, even if i delete the original picture, it still
keeps the picture property, it must be binary keept in somewhere...
--
--
---
ZZ [underground]
Semi-musico,cuasi-poeta y loco



"Tom Ogilvy" <(E-Mail Removed)> wrote in message
news:526DA730-1AD2-4719-B7FB-(E-Mail Removed)...
> In the workbook file itself.
>
> --
> Regards,
> Tom Ogilvy
>
>
> "zz" wrote:
>
>> it's more an 'existencialist' question than a thecnical one
>>
>> Where does excel store the pictures of a userform's 'Picture' property?
>>
>>
>> --
>> --
>> ---
>> ZZ [underground]
>> Semi-musico,cuasi-poeta y loco



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      19th Jan 2007
Try creating two userforms.

One with a picture and one completely empty.

Export each of those to a folder.

Look at the .frx files that were generated.

But now that you know that the pictures are buried in that .frx file, whatcha
gonna do?

Those files look pretty greek to me.

zz wrote:
>
> :=/
>
> but if i export the userform and import it later in another workbook, it
> keeps the property too, even if i delete the original picture, it still
> keeps the picture property, it must be binary keept in somewhere...
> --
> --
> ---
> ZZ [underground]
> Semi-musico,cuasi-poeta y loco
>
> "Tom Ogilvy" <(E-Mail Removed)> wrote in message
> news:526DA730-1AD2-4719-B7FB-(E-Mail Removed)...
> > In the workbook file itself.
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> > "zz" wrote:
> >
> >> it's more an 'existencialist' question than a thecnical one
> >>
> >> Where does excel store the pictures of a userform's 'Picture' property?
> >>
> >>
> >> --
> >> --
> >> ---
> >> ZZ [underground]
> >> Semi-musico,cuasi-poeta y loco


--

Dave Peterson
 
Reply With Quote
 
zz
Guest
Posts: n/a
 
      19th Jan 2007
i'm gonna do nothing with it, it's just that i created a userform with four
image controls, each with a different picture, so when i click one of them
the main userform gets it's picture property from the image control's
..picture property, instead of loading it from a path, this way i prevent an
error if the user deletes the picture,

but then question came to my mind, where is the picture being kept, i knew
the behavior but didn't knew the reason, now i know a little more than a few
hours ago.

now i have the options dialog for my application and some greek lessons to
take! :-D

thanks a lot.


--
--
---
ZZ [underground]
Semi-musico,cuasi-poeta y loco


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try creating two userforms.
>
> One with a picture and one completely empty.
>
> Export each of those to a folder.
>
> Look at the .frx files that were generated.
>
> But now that you know that the pictures are buried in that .frx file,
> whatcha
> gonna do?
>
> Those files look pretty greek to me.
>
> zz wrote:
>>
>> :=/
>>
>> but if i export the userform and import it later in another workbook, it
>> keeps the property too, even if i delete the original picture, it still
>> keeps the picture property, it must be binary keept in somewhere...
>> --
>> --
>> ---
>> ZZ [underground]
>> Semi-musico,cuasi-poeta y loco
>>
>> "Tom Ogilvy" <(E-Mail Removed)> wrote in message
>> news:526DA730-1AD2-4719-B7FB-(E-Mail Removed)...
>> > In the workbook file itself.
>> >
>> > --
>> > Regards,
>> > Tom Ogilvy
>> >
>> >
>> > "zz" wrote:
>> >
>> >> it's more an 'existencialist' question than a thecnical one
>> >>
>> >> Where does excel store the pictures of a userform's 'Picture'
>> >> property?
>> >>
>> >>
>> >> --
>> >> --
>> >> ---
>> >> ZZ [underground]
>> >> Semi-musico,cuasi-poeta y loco

>
> --
>
> Dave Peterson



 
Reply With Quote
 
Tom Ogilvy
Guest
Posts: n/a
 
      21st Jan 2007
> But now that you know that the pictures are buried in that .frx file

What??

--
Regards,
Tom Ogilvy




"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Try creating two userforms.
>
> One with a picture and one completely empty.
>
> Export each of those to a folder.
>
> Look at the .frx files that were generated.
>
> But now that you know that the pictures are buried in that .frx file,
> whatcha
> gonna do?
>
> Those files look pretty greek to me.
>
> zz wrote:
>>
>> :=/
>>
>> but if i export the userform and import it later in another workbook, it
>> keeps the property too, even if i delete the original picture, it still
>> keeps the picture property, it must be binary keept in somewhere...
>> --
>> --
>> ---
>> ZZ [underground]
>> Semi-musico,cuasi-poeta y loco
>>
>> "Tom Ogilvy" <(E-Mail Removed)> wrote in message
>> news:526DA730-1AD2-4719-B7FB-(E-Mail Removed)...
>> > In the workbook file itself.
>> >
>> > --
>> > Regards,
>> > Tom Ogilvy
>> >
>> >
>> > "zz" wrote:
>> >
>> >> it's more an 'existencialist' question than a thecnical one
>> >>
>> >> Where does excel store the pictures of a userform's 'Picture'
>> >> property?
>> >>
>> >>
>> >> --
>> >> --
>> >> ---
>> >> ZZ [underground]
>> >> Semi-musico,cuasi-poeta y loco

>
> --
>
> Dave Peterson



 
Reply With Quote
 
Dave Peterson
Guest
Posts: n/a
 
      21st Jan 2007
I guess that was misleading.

I was trying to say that when the userform is exported to a file, then the
picture travels with it. Not that the pictures are actually stored in an
external file.

I have no idea where inside that workbook excel actually stores the picture.


Tom Ogilvy wrote:
>
> > But now that you know that the pictures are buried in that .frx file

>
> What??
>
> --
> Regards,
> Tom Ogilvy
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Try creating two userforms.
> >
> > One with a picture and one completely empty.
> >
> > Export each of those to a folder.
> >
> > Look at the .frx files that were generated.
> >
> > But now that you know that the pictures are buried in that .frx file,
> > whatcha
> > gonna do?
> >
> > Those files look pretty greek to me.
> >
> > zz wrote:
> >>
> >> :=/
> >>
> >> but if i export the userform and import it later in another workbook, it
> >> keeps the property too, even if i delete the original picture, it still
> >> keeps the picture property, it must be binary keept in somewhere...
> >> --
> >> --
> >> ---
> >> ZZ [underground]
> >> Semi-musico,cuasi-poeta y loco
> >>
> >> "Tom Ogilvy" <(E-Mail Removed)> wrote in message
> >> news:526DA730-1AD2-4719-B7FB-(E-Mail Removed)...
> >> > In the workbook file itself.
> >> >
> >> > --
> >> > Regards,
> >> > Tom Ogilvy
> >> >
> >> >
> >> > "zz" wrote:
> >> >
> >> >> it's more an 'existencialist' question than a thecnical one
> >> >>
> >> >> Where does excel store the pictures of a userform's 'Picture'
> >> >> property?
> >> >>
> >> >>
> >> >> --
> >> >> --
> >> >> ---
> >> >> ZZ [underground]
> >> >> Semi-musico,cuasi-poeta y loco

> >
> > --
> >
> > Dave Peterson


--

Dave Peterson
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Picture AlternativeText property Equivalent in Excel 97 Mishell Microsoft Excel Programming 1 15th Mar 2010 05:11 PM
How to copy a graph from excel to userform picture? Yajiv Microsoft Excel Programming 1 1st Mar 2008 08:49 PM
userform Enabled property behavior changes between excel 97 and 2000/3 Nicholas Dreyer Microsoft Excel Programming 2 20th Sep 2006 05:01 AM
changing property of a picture that is already pasted on excel =?Utf-8?B?Y2M=?= Microsoft Excel New Users 0 27th Jun 2006 05:04 AM
Re: Excel form picture property error 481 Nick Hodge Microsoft Excel Crashes 1 6th Oct 2003 02:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:01 AM.