Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
zz zz is offline
external usenet poster
 
Posts: 14
Default Where does excel store the pictures of a userform's 'Picture' property?

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
zz zz is offline
external usenet poster
 
Posts: 14
Default Where does excel store the pictures of a userform's 'Picture' prop

:=/

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" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Where does excel store the pictures of a userform's 'Picture' prop

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" wrote in message
...
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
  #4   Report Post  
Posted to microsoft.public.excel.programming
zz zz is offline
external usenet poster
 
Posts: 14
Default Where does excel store the pictures of a userform's 'Picture' prop

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" wrote in message
...
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" wrote in message
...
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



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Where does excel store the pictures of a userform's 'Picture' prop

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

What??

--
Regards,
Tom Ogilvy




"Dave Peterson" wrote in message
...
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" wrote in message
...
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





  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default Where does excel store the pictures of a userform's 'Picture' prop

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" wrote in message
...
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" wrote in message
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
import picture taken data from my pictures directory into excell? John VanNierop Excel Discussion (Misc queries) 7 July 6th 10 01:03 PM
how do I sort an excel list that includes pictures (name-picture) Angelke Excel Discussion (Misc queries) 1 January 29th 08 02:46 PM
Macro to delete various pictures and hyper-link picture icons Steve Excel Worksheet Functions 13 December 5th 06 09:39 PM
changing property of a picture that is already pasted on excel cc New Users to Excel 0 June 27th 06 05:04 AM
Picture Tiling property Tom Ogilvy Excel Programming 0 February 1st 04 08:36 PM


All times are GMT +1. The time now is 04:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"