Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Adding Images

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?



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
Adding pictures, images or objects darkside7out Excel Discussion (Misc queries) 1 March 10th 10 02:05 AM
Chart.Export images are shrinking as I export more images Jared Charts and Charting in Excel 3 January 29th 08 04:23 AM
adding images to excel table automatically Grafula Excel Discussion (Misc queries) 1 March 14th 06 09:33 AM
Images Ren Excel Programming 1 January 27th 05 08:47 PM
*.gif images Mischa Browne[_2_] Excel Programming 4 July 16th 04 03:18 PM


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

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

About Us

"It's about Microsoft Excel"