- ©«¤l
- 471
- ¥DÃD
- 121
- ºëµØ
- 0
- ¿n¤À
- 579
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-16
- ³Ì«áµn¿ý
- 2023-1-17
|
1.Sheets("¤¤ë")<½Ð°ÝÃö©ó©p©Ò»¡ªºÅܼÆ
°²¦p¦bÓ§O«È¤á©ú²Ó(Q3)°µ¤@Ó²M³æ ¤@~¤Q¤G¤ë,¨º¦³¤°»ò«ü¥O¥i¥HÅý"¤¤ë" ¥hŪ¨ú¨ºÓ¦ì¸mÅܦ¨°ÊºA©O? cells(Q3) ³o¼Ë¶Ü?
Workbooks.Open ("½Æ»sªº¸ô®|" & "\" & "«È¤á©ú²Ó-·~°È±M¥Î.xlsm")
¦]«È¤á©ú²Ó-·~°È±M¥Î.xlsm·|¦³¦n´XÓ·~°Èªº,¦p \\..\..\..\..\·~°È±M¥Î ¤º¦³¤£¦P·~°Èªº¸ê®Æ§¨,¦A¤U¤@¼h¤~·|¬O«È¤á©ú²Ó-·~°È±M¥Î.xlsm
©Ò¥H¥i¥H¥Î
Workbooks.Open (" \\..\..\..\..\·~°È±M¥Î" &"¤£¦P·~°Èªº¸ê®Æ§¨(¨ÌO3¤º®eªº¦WºÙÅܧó)"& "\" & "«È¤á©ú²Ó-·~°È±M¥Î.xlsm")
¦p·~°È±M¥Î(½Æ»s¸ô®|)," &"·~°È-±i, "& "\" & "«È¤á©ú²Ó-·~°È±M¥Î.xlsm" ¹³³o¼Ë¥i¥H¹F¦¨¶Ü |
|