ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] icon¸ô®|°ÝÃD

¦^´_ 10# li_hsien

   
³£¤£¬O«ü©w¹ê»Úªºªø¼e¡A¦Ó¶È¬O«ü¬Y­ÓÀx¦s®æªº¬Û¹ï¦ì¸m§a???

¹ïªº¥Ü½d°t¦XÀx¦s®æªºªø¼e°ª,§A¤]¥i¥Hµ¹¥¦«ü©wªº¼Æ¦r
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_ 11# GBKEE


    ·PÁÂGBKEEª©¤j

    ¤p§ÌÁA¸Ñ

    TKS~
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

¦^´_ 6# li_hsien
¦^´_ 8# GBKEE

­É¥ÎªO¤jªº¨Ò¤l¡A¦]¦Û¤v°õ¦æ«á ¼e©M°ª¤´µLªk©MÀx¦s®æ¤@¼Ë
­ì¦]¬O·s¼Wªº¹Ï¥Üªø¼e¤ñ·|Âê©w
²`¤J¸Óª«¥óªºÄÝ©Ê´M§ä
µo²{¥i¥H¨Ï¥Î.ShapeRange.LockAspectRatio = msoFalse ¸Ñ°£Âê©w
  1. Sub Ex()
  2.     Dim i
  3.     i = 5
  4.     With ActiveSheet.OLEObjects.Add(Filename:="D:\test.xls", Link:=False,  DisplayAsIcon:=True, _
  5.         IconFileName:="C:\WINDOWS\Installer\{AC76BA86-7AD7-1028-7B44-A93000000001}\PDFFile_8.ico", _
  6.         IconIndex:=0) , IconLabel:=Range("A" & i))
  7.         .Top = Range("B" & i).Top        '«ü©w³»³¡¦ì¸m
  8.         .Left = Range("B" & i).Left      '«ü©w¥kÃä¦ì¸m
  9.         .ShapeRange.LockAspectRatio = msoFalse
  10.         .Height = Range("B" & i).Height  '«ü©w°ª«×
  11.         .Width = Range("B" & i).Width    '«ü©w¼e«×        
  12.     End With   
  13. End Sub
½Æ»s¥N½X

TOP

¦^´_ 13# stillfish00
Ex()ªºµ{¦¡½X¥Ü½d¨Ì«ü©wÀx¦s®æªºªø¼e©M°ª,¨Ó«ü©wª«¥óªºªø¼e°ª.

¼e©M°ª¤´µLªk©MÀx¦s®æ¤@¼Ë!!!  ¬°¦ó·|¦p¦¹»¡???
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ stillfish00 ©ó 2014-10-27 16:31 ½s¿è

¦^´_ 14# GBKEE





´N¬O½Õ¾ã°ª®É¡A¥L¦Û¤v·|¦Û°Êµ¥¤ñ¨Ò½Õ¾ã¼e
¦Ó¦A¤@¦¸½Õ¾ã¼e®É¡A¥L¤S¦Û°Êµ¥¤ñ¨Ò½Õ¾ã°ª...
§A­Ì¤£·|³o¼Ë¶Ü?

§Ú¬O±À´ú¬O³o­Ó"Âê©wªø¼e¤ñ"³y¦¨ªº°Õ:




PS: #13¼Ó¦³µ§»~ IconIndex:=0)   ¦h¤F¤@­Ó ")"

TOP

¦^´_ 15# stillfish00

·PÁª©¤j©Mstillish00
¤@¶}©l¦³·Q¨ì¬O¤ñ¨Ò©Ò³y¦¨ªº°ÝÃD¡A¥i¬Oµo²{©³¤UªºÄݩʨS¦³³o¤@¶µ
©Ò¥H§@½}

¸gstillfish00´£ÂI¡A¤~ª¾¹D¬O³o¼Ë¾Þ§@
.ShapeRange.LockAspectRatio = msoFalse ¸Ñ°£Âê©w

¤£¹L«á¨Ó§Ú¥Îªº¤è¦¡¬O³o¼Ë
  1. Dim PDF As OLEObject

  2. Set PDF = ActiveSheet.OLEObjects.Add(XXXXX)

  3. PDF.Height = 42.75
  4. PDF.Width = 57.75
½Æ»s¥N½X
µ²ªGµo²{¥i¦æ

«¢«¢ ´N³o¼Ë¾Þ§@¤F

¤]¤£²M·¡³o¼Ë°õ¦æO¤£OK
¥Î¥\¨ì¥@¬É¥½¤é¨º¤@¤Ñ¡ã¡ã¡ã

TOP

¦^´_ 15# stillfish00

   
´N¬O½Õ¾ã°ª®É¡A¥L¦Û¤v·|¦Û°Êµ¥¤ñ¨Ò½Õ¾ã¼e
¦Ó¦A¤@¦¸½Õ¾ã¼e®É¡A¥L¤S¦Û°Êµ¥¤ñ¨Ò½Õ¾ã°ª...
§A­Ì¤£·|³o¼Ë¶Ü?

2003ª©ªº¤£·|°Ú

·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD