Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Activesheet.Pictures.Insert

Can I control the position and size of the picture programmatically?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 46
Default Activesheet.Pictures.Insert

ActiveSheet.Pictures.Insert("L:\untitled2.bmp").Se lect
Selection.ShapeRange.ScaleWidth 0.56, msoFalse,
msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.56, msoFalse,
msoScaleFromTopLeft
Selection.ShapeRange.IncrementLeft 164.25
Selection.ShapeRange.IncrementTop 81.75

-----Original Message-----
Can I control the position and size of the picture

programmatically?
.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 18
Default Activesheet.Pictures.Insert

Thanks.


On Tue, 23 Sep 2003 16:49:54 -0700, "Bill Li"
wrote:

ActiveSheet.Pictures.Insert("L:\untitled2.bmp").Se lect
Selection.ShapeRange.ScaleWidth 0.56, msoFalse,
msoScaleFromTopLeft
Selection.ShapeRange.ScaleHeight 0.56, msoFalse,
msoScaleFromTopLeft
Selection.ShapeRange.IncrementLeft 164.25
Selection.ShapeRange.IncrementTop 81.75

-----Original Message-----
Can I control the position and size of the picture

programmatically?
.


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
Can't insert pictures laurie New Users to Excel 2 April 5th 23 01:21 PM
Allowing insert pictures in a protected worksheet GeekGirl Excel Discussion (Misc queries) 0 April 3rd 09 11:54 AM
Insert pictures AZU Excel Discussion (Misc queries) 5 March 6th 09 05:28 PM
Need Help with auto insert of pictures Bradley Wolosz New Users to Excel 3 August 25th 08 12:28 PM
can't insert, delete or move pictures parker Excel Discussion (Misc queries) 1 February 18th 05 01:03 AM


All times are GMT +1. The time now is 06:39 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"