- ©«¤l
- 4901
- ¥DÃD
- 44
- ºëµØ
- 24
- ¿n¤À
- 4916
- ÂI¦W
- 124
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 20xx
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_
- µù¥U®É¶¡
- 2010-4-30
- ³Ì«áµn¿ý
- 2024-5-29
|
¦^´_ 1# li_hsien
¼Ó¥DÀ³¸Ó¬O·Qn±N¬Y¨Ç«ü©wÀɦWªºÀɮײ¾°Ê¨ì¯S©w¥Ø¿ý¤º
°²³]ÀɦW(¤£¥[°ÆÀɦW)©ñ¸m©ó¤u§@ªíAÄæ- Sub ex()
- Dim A As Range
- Set fds = CreateObject("Scripting.FileSystemObject")
- With Application.FileDialog(msoFileDialogFolderPicker)
- .Title = "¿ï¾ÜPDFì¥ý¸ê®Æ§¨"
- .Show
- ofd = .SelectedItems(1) & "\"
- End With
- With Application.FileDialog(msoFileDialogFolderPicker)
- .Title = "¿ï¾ÜPDF¥Øªº¸ê®Æ§¨"
- .Show
- fd = .SelectedItems(1) & "\"
- End With
- With ¤u§@ªí1 '¿é¤JÀɦWªº¤u§@ªí
- For Each A In .Range(.[A1], .[A1].End(xlDown))
- fs = Dir(ofd & A & ".pdf")
- If fs <> "" Then fds.movefile ofd & fs, fd & fs '²¾°ÊÀÉ®×
- Next
- End With
- End Sub
½Æ»s¥N½X |
|