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

[zz]

it's more an 'existencialist' question than a thecnical one

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

 

[zz]

:=/

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...

 

[Dave Peterson]

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.

:=/

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

In the workbook file itself.

 

[zz]

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

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.

:=/

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

In the workbook file itself.

--
Regards,
Tom Ogilvy


:

it's more an 'existencialist' question than a thecnical one

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


--

 

[Tom Ogilvy]

But now that you know that the pictures are buried in that .frx file

What??

--
Regards,
Tom Ogilvy

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.

:=/

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

In the workbook file itself.

--
Regards,
Tom Ogilvy


:

it's more an 'existencialist' question than a thecnical one

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


--

 

[Dave Peterson]

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.

But now that you know that the pictures are buried in that .frx file

What??

--
Regards,
Tom Ogilvy

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.

:=/

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

In the workbook file itself.

--
Regards,
Tom Ogilvy


:

it's more an 'existencialist' question than a thecnical one

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


--