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

¥¨¶°¤¤ÀɦW=ExcelÀx¦s®æªºD3

¥¨¶°¤¤ÀɦW=ExcelÀx¦s®æªºD3

¦U¦ì¤j¤j,
½Ð°Ý§Ú­n¦p¦ó§ï³o¥y¥¨¶°? Workbooks("NEJ-¿é¥X¥Í¦a_³¡§÷¸Ô²Ó COLOR HERRINGBONE BCM.xlsx").Activate
¦b¥¨¶°¤¤«ü©w¤@­ÓÀɮתº¦WºÙ=file name"¸Ñ½X" sheet "answer"ªº"D3"ªº"NEJ-¿é¥X¥Í¦a_³¡§÷¸Ô²Ó COLOR HERRINGBONE BCM.xlsx"

°²³]"¤u§@ï"¸Ñ½X¤w¥´¶}.
workbooks("¸Ñ½X").worksheets("answer").range("D3").value
¥i±o¥X "¸Ñ½X"¸Ì"ANSWER"­¶ D3¦ì¸mªº­È.

Workbooks(workbooks("¸Ñ½X").worksheets("answer").range("D3").value).Activate
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

RE: ¥¨¶°¤¤ÀɦW=ExcelÀx¦s®æªºD3

¦^´_ 2# kimbal
·PÁÂ,°õ¦æ¨S°ÝÃD!

TOP

        ÀR«ä¦Û¦b : ¨ü¤HÂI¤ô¤§®¦¡A¶··í´é¬u¥H³ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD