- ©«¤l
- 65
- ¥DÃD
- 0
- ºëµØ
- 0
- ¿n¤À
- 120
- ÂI¦W
- 0
- §@·~¨t²Î
- Win 7
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2010-5-15
- ³Ì«áµn¿ý
- 2010-7-16
|
½Ð°Ý§A¬O·Qn¥t¦s·sÀɦA¶}±ÒìÀɮ׶Ü?
½Ð°Ñ¦Ò
Orig = ThisWorkbook.Path & "\" & ThisWorkbook.Name '¨ú±oìÀɮ׸ô®|¤Î¦WºÙ
ActiveWorkbook.SaveAs Filename:="D:\" & Range("B1").Value & Range("B3").Value & ".xls" ' ¨Ìn¨DB1&B3¤º®e¥t¦s·sÀÉ
newfile = ActiveWorkbook.Name
Workbooks.Open Filename:=Orig ' ¶}±ÒìÀÉ®×
Workbooks(newfile).Close ' Ãö³¬¥t¦s¤§ÀÉ®×
µù. ¥t¦s·sÀɤ§«eªºÅܧ󤣷|¦s¦b©óìÀɮ׳á |
|