jackdream

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

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

basarasy

¦^´_ 7# luhpro

°ÝÃD¬O³o­Ó¦³¿ù,¤£¯à¥Î.
    MyName = Workbooks("book2.xls").Sheet1.Name

luhpro

¦^´_ 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¶Ü?

basarasy

¦^´_ 5# kimbal
¦]¬°§Ú·Q­n sheet1.name   ¥Î³o­Ósheet§ï¦W¤F³£¥i¥Hrun¨ì
eg.  sheet1(sheet1)>sheet1(¤H¦W)

kimbal

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

¬°¦ó¤@©w­n¥Î sheet1.xxx?

basarasy

¦^´_ 3# kimbal
¤£¥i¥H³o¼Ë¶Ü?
MyName = Workbooks("book2.xls").Sheet1.Name
¤£·Q¨C¦¸sheet§ï¤F¦W ³£­n¨ìvba §ï.

kimbal

¸É¥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"

jackdream

¦^´_ 1# basarasy

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