I haven't run into that since many, many years ago. I know Microsoft has
had that problem with office apps of and one, but don't know the specific
cause or cure.
Might do a google search or go to
http://support.microsoft.com
and search the knowledge base.
--
Regards,
Tom Ogilvy
"Dan Kelly" wrote in message
...
Okay got a bit further
Using the following code:
ActiveSheet.Pictures.Insert("Y:\Templates\Test\Log os\CoolGrey.jpg").Select
Selection.ShapeRange.Top = 29.25
Selection.ShapeRange.Left = 323.25
Selection.ShapeRange.Height = 44.25
I get a "red x" in an appropriatly shaped box on the form :)
How do I stop the red "x" from happening?
Dan
That's great - I now know what the position of the images is going to be
and
can work that out for the multiples.
I just need to know how to add the image to the Sheet :)
The First Image needs to be added from the Following location:
"Y:\Templates\Logos\Grey.jpg"
But I can only get a red "x"
Subsequent images on a sheet can be copies of the first, just at the new
position.
"Tom Ogilvy" wrote:
Activesheet.Pictures(1).Top
Activesheet.Pictures(1).Left
from the immediate window as a demo:
?ActiveSheet.Pictures(1).Top
1326
? activesheet.Pictures(1).TopLeftCell.Top
1326
? activesheet.Pictures(1).TopLeftCell.Address(0,0)
E105
--
regards,
Tom Ogilvy
"Dan Kelly" wrote:
Last couple of questions I hope - both related to images.
I have a standard Template that I am trying to replicate in VB in
order to
do allow an office rebrand to occur. The new designed template has
an image
on it, whose picture I am trying to find out - but there seems to be
no
information about position available.
Once I know the position of the image I want to insert the image into
the
correct position on the newly created page.
Any pointers?