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

sheet name °ÝÃD

sheet name °ÝÃD

¥»©«³Ì«á¥Ñ basarasy ©ó 2010-7-27 17:15 ½s¿è

§Ú¦bbook1 ¥´vba  open book2   

  MyName=sheet1.name ¦³°ÝÃD.
§Ú¬O·Q­nbook2ªºsheet1.name
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# basarasy

¦pªG½T©w¶}±ÒªºÀɦW¬O book2.xls
»yªk½Ð§ï¬° MyName = Workbooks("book2.xls").Sheets(1).Name

TOP

¸É¥R:

¤u§@ªí¤WÅã¥Üªº¦W
MyName = Workbooks("book2.xls").Sheets("Sheet1").Name
¤]¬O´N¬O sheet1 ....

¦pªG§A´¿¸g¦bvbe¨ºÃä§âsheet§ï¤F¦W¬° abc
abc.name = "sheet1"
abc.codename = "abc"
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 3# kimbal
¤£¥i¥H³o¼Ë¶Ü?
MyName = Workbooks("book2.xls").Sheet1.Name
¤£·Q¨C¦¸sheet§ï¤F¦W ³£­n¨ìvba §ï.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

ª½±µ³o¼Ë¨Ó©I¥s¤]¥i¥H§a
Workbooks("book2.xls").Sheets("Sheet1")

¬°¦ó¤@©w­n¥Î sheet1.xxx?
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 5# kimbal
¦]¬°§Ú·Q­n sheet1.name   ¥Î³o­Ósheet§ï¦W¤F³£¥i¥Hrun¨ì
eg.  sheet1(sheet1)>sheet1(¤H¦W)
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 6# basarasy

§Úı±o 2# ªº Sheets(1).Name À³¸Ó´N¬O§A·Q­nªºµª®×¤F°Ú?

¤£ºÞ§Aªº Sheet name ¦p¦óÅܧó,
¥u­n½T©w¬O§ì ²Ä n ­Ó Sheet,
§_«h§A­Y¥Î Sheets("Sheet1") ¤§Ãþªº¤è¦¡,
¤w¸g´N©w¦º¤F§A­n§äªº Sheet name ¤F¤£¬O¶Ü?

TOP

¦^´_ 7# luhpro

°ÝÃD¬O³o­Ó¦³¿ù,¤£¯à¥Î.
    MyName = Workbooks("book2.xls").Sheet1.Name
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

°ÝÃD¬O³o­Ó¦³¿ù,¤£¯à¥Î.
    MyName = Workbooks("book2.xls").Sheet1.Name
basarasy µoªí©ó 2010-7-27 20:13


¬O MyName = Workbooks("book2.xls").Sheets(1).Name

TOP

¦^´_ 9# jackdream
Workbooks("book2.xls").Activate
MyName = Sheets(1).Name ³o¥y¬O¥ªÃä¨ì¥k²Ä1­Ósheet
¦pªG¶Ã¤F  sheet3 sheet2 sheet1  ´N¤£¯à«ü©wsheet1¤F.
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD