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

[µo°Ý] Ãö©óExcel VBA ½d¥» §ä¤£¨ì¸ô®|°ÝÃD

[µo°Ý] Ãö©óExcel VBA ½d¥» §ä¤£¨ì¸ô®|°ÝÃD

¤£¦n·N«ä¡A·s¤â°ÝÃD

¦b¤@¯ëExcelÀɮפ¤¡A¥i¥H
  1.    
  2. Dim MyPath As String
  3. MyPath = ActiveWorkbook.Path
  4. MsgBox (MyPath)
½Æ»s¥N½X
¬d¸ßExcelÀɮ׸ô®|¡A¦ý¬O·í¦¹ÀÉ®×Àx¦s¬°½d¥»®É¡A¦A¦¸°õ¦æ¥H¤W«ü¥O¡A·|¥X²{"§ä¤£¨ì¸ô®|"¡AÀ³¸Ó¦p¦ó­×§ï¤~¯à¬d¸ß¦¹½d¥»¥Ø«e©Ò¦b¤§¸ô®|©O¡H

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD