½Ð°Ývba¨Ï¥Î¨t²Î¤º«Ø¨Ó¸ÑÀ£ÁYzip??
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¦^´_ 1# lshsien
§A¼g¤Ï¤F§a
Fname = Worksheets("¤u§@ªí1").Range("F2").value '±qF2¨ú±ozipÀɸô®|
FileNameFolder = ThisWorkbook.Path & "\" & folder_name & "\" '¸ÑÀ£ÁY¦ì¸m
Set oApp = CreateObject("Shell.Application")
oApp.Namespace(FileNameFolder).CopyHere oApp.Namespace(Fname).items |
|
|
|
|
|
|
- ©«¤l
- 1018
- ¥DÃD
- 15
- ºëµØ
- 0
- ¿n¤À
- 1058
- ÂI¦W
- 0
- §@·~¨t²Î
- win7 32bit
- ³nÅ骩¥»
- Office 2016 64-bit
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ®ç¶é
- µù¥U®É¶¡
- 2012-5-9
- ³Ì«áµn¿ý
- 2022-9-28
|
¥»©«³Ì«á¥Ñ stillfish00 ©ó 2014-11-5 00:09 ½s¿è
¦^´_ 6# »k¥ú°j¯T
Y¬O¤@ÓÀɮפ@Ó¸ê®Æ§¨:- Option Explicit
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- Dim gb As FileDialog '«Å§i¤@ÓÀÉ®×¹ï¸Ü®Ø
- Dim fd As FileDialog '«Å§i¤@ÓÀÉ®×¹ï¸Ü®Ø
- With Target(1)
- If .Address = "$B$1" Then
- Set gb = Excel.Application.FileDialog(msoFileDialogFilePicker) '³]©w¿ï¨úÀÉ®×¥\¯à
- If gb.Show Then .Cells = gb.SelectedItems(1) 'ÂI¿ïþÓÄæ¦ìÀx¦s®æ,Àɮ׸ô®|¨q¦b¨ºÓÄæ¦ì
- ElseIf .Address = "$B$2" Then
- Set fd = Application.FileDialog(msoFileDialogFolderPicker) '³]©w¿ï¨ú¸ê®Æ§¨¥\¯à
- If fd.Show Then .Cells = fd.SelectedItems(1) 'ÂI¿ïþÓÄæ¦ìÀx¦s®æ,Àɮ׸ô®|¨q¦b¨ºÓÄæ¦ì
- End If
- End With
- End Sub
½Æ»s¥N½X |
|
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C
|
|
|
|
|