½Ð°Ývba¨Ï¥Î¨t²Î¤º«Ø¨Ó¸ÑÀ£ÁYzip??
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 37
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-4-15
- ³Ì«áµn¿ý
- 2019-1-15
|
½Ð°Ývba¨Ï¥Î¨t²Î¤º«Ø¨Ó¸ÑÀ£ÁYzip??
±z¦n!
½Ð±Ð¦U¦ì«e½ú
¥Ø«e¤p§Ì·Q¨Ï¥Î¥H¤U¨Ó¸ÑÀ£ÁY
Fname = Application.GetOpenFilename(filefilter:="Zip Files (*.zip), *.zip", MultiSelect:=False)
FileNameFolder = ThisWorkbook.Path & "\" & folder_name & "\"
Worksheets("¤u§@ªí1").Range("F2") = FileNameFolder
Set oApp = CreateObject("Shell.Application")
oApp.Namespace(FileNameFolder).CopyHere oApp.Namespace(Fname).items
¥Ø«e´ú¸Õ¦¨¥\¡A
¦ý¨Ï¥Î³o¤è¦¡¡AÁٻݿï¾Ü©Ò»Ýn¸ÑÁYªºÀɮסA
½Ð°Ý¬O§_¥i¥H¤£»Ý¿ï¾Ü¦Ó¦Û¦æ¸ÑÀ£ÁY
ps.ÀɮצWºÙ»P¸ê®Æ§¨¦WºÙÂ^¨ú¦ÛWorksheets("¤u§@ªí1").Range("F2")
¸ü·Ð½Ð¦U¦ì«e½ú«ü¾É
ÁÂÁÂ |
|
|
|
|
|
|
- ©«¤l
- 6
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 37
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office2010
- ¾\ŪÅv
- 10
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-4-15
- ³Ì«áµn¿ý
- 2019-1-15
|
·PÁ»k¥ú°j¯T¤j¤j
¤w¸g¸ÕÅ禨¥\¤F
·PÁÂstillfish00§ó¥¿ |
|
|
|
|
|
|