Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding pictures, images or objects | Excel Discussion (Misc queries) | |||
Chart.Export images are shrinking as I export more images | Charts and Charting in Excel | |||
adding images to excel table automatically | Excel Discussion (Misc queries) | |||
Images | Excel Programming | |||
*.gif images | Excel Programming |