ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What does _v0000 mean on the name box? (https://www.excelbanter.com/excel-discussion-misc-queries/49205-what-does-_v0000-mean-name-box.html)

Martn

What does _v0000 mean on the name box?
 
I am working with vb application that goes through excel worksheets which
have pictures in it. The pictures that were addressable have 'Picture 1' in
the Name box and my code could access them because
Worksheet(1).Pictures.Count returns a non zero value. For those pictures that
when clicked shows a label in the Name box as '_v0000' , the expression
Worksheet(2).Pictures.Count returns a 0, which means that it is not
recognizing that as a picture.
Is there any other object or collection other than Pictures that those
identified with _v0000 pertain to?
Thanks !


Jim Rech

"Shapes" or "DrawingObjects" can probably access it.

--
Jim
"Martn" wrote in message
...
|I am working with vb application that goes through excel worksheets which
| have pictures in it. The pictures that were addressable have 'Picture 1'
in
| the Name box and my code could access them because
| Worksheet(1).Pictures.Count returns a non zero value. For those pictures
that
| when clicked shows a label in the Name box as '_v0000' , the expression
| Worksheet(2).Pictures.Count returns a 0, which means that it is not
| recognizing that as a picture.
| Is there any other object or collection other than Pictures that those
| identified with _v0000 pertain to?
| Thanks !
|



Martn

thanks, Jim.
DrawingObjects worked!

"Jim Rech" wrote:

"Shapes" or "DrawingObjects" can probably access it.

--
Jim
"Martn" wrote in message
...
|I am working with vb application that goes through excel worksheets which
| have pictures in it. The pictures that were addressable have 'Picture 1'
in
| the Name box and my code could access them because
| Worksheet(1).Pictures.Count returns a non zero value. For those pictures
that
| when clicked shows a label in the Name box as '_v0000' , the expression
| Worksheet(2).Pictures.Count returns a 0, which means that it is not
| recognizing that as a picture.
| Is there any other object or collection other than Pictures that those
| identified with _v0000 pertain to?
| Thanks !
|





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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com