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

[µo°Ý] ¦p¦ó§Q¥ÎVBA°µÀx¦s®æªº¥[Á`

Àx¦s¸ô®|¤¤·s¼WA2Àx¦s®æ

Save_Name = "\\pc-1000331\Users\142121\123.xls"
­Y­n¦b123.xls«e¥[¤W¤u§@ªí1ªºA2Àx¦s®æ¸ê®Æ~¬O§_¦p¤U?
Save_Name = "\\pc-1000331\Users\142121\" & ¤u§@ªí1.[A2] & "123.xls"

TOP

¦^´_ 1# av8d


    ¦pªG­n¥[Á`D2:D50¬O & ¤u§@ªí1.[D2:D50].Count  ??

TOP

[µo°Ý] ¦p¦ó§Q¥ÎVBA°µÀx¦s®æªº¥[Á`

SumA=SUM(A1:A10)

OutPut="\\127.0.0.1\" & SumA & "MyExcel.xls"

¥H¤W·|¥X²{°ÝÃD~¸Ó¦p¦ó§ï¼g?

¦^´_ 3# av8d


    §ä¨ì¤F~http://forum.twbts.com/viewthread.php?tid=6699

¦A¦¸·PÁÂGªO¥Dªº¥Î¤ß~
1

µû¤À¤H¼Æ

    • GBKEE: ¦³¶i¨Bª÷¿ú + 1

TOP

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