Unzip a folder and copy all the files inside the folder to a different folder

[mali10020]

Good morning guys!!

please assist if you can!!

I want this code to unzip the latest folder in Dir and copy all the files inside that folder to a different folder and open the bigest file in the folder

Sub Unzip1()
Dim FSO As Object
Dim oApp As Object
Dim Fname As Variant
Dim FileNameFolder As Variant
Dim DefPath As String
Dim strDate As String

Fname = Application.GetOpenFilename(filefilter:="Zip Files (*.zip), *.zip", _
MultiSelect:=False)
If Fname = False Then
'Do nothing
Else
'Root folder for the new folder.
'You can also use DefPath = "C:\Apps\CipherRounds_1633694385.zip"
DefPath = Application.DefaultFilePath
If Right(DefPath, 1) <> "\" Then
DefPath = DefPath & "\"
End If

'Create the folder name
strDate = Format(Now, " dd-mm-yy h-mm-ss")
FileNameFolder = DefPath & "MyUnzipFolder " & strDate & "\"

'Make the normal folder in DefPath
MkDir FileNameFolder

'Extract the files into the newly created folder
Set oApp = CreateObject("Shell.Application")

oApp.Namespace(FileNameFolder).CopyHere oApp.Namespace(Fname).Items

'If you want to extract only one file you can use this:
'oApp.Namespace(FileNameFolder).CopyHere _
'oApp.Namespace(Fname).items.Item("test.txt")

MsgBox "You find the files here: " & FileNameFolder

On Error Resume Next
Set FSO = CreateObject("scripting.filesystemobject")
FSO.DeleteFolder Environ("Temp") & "\Temporary Directory*", True
End If

'ActiveWorkbook.Worksheets("").CopyWorkbooks("Mobile").Worksheets ("Device name")
'ActiveSheet.name = NewestFile.name
Cells.Select
Selection.Copy
Application.DisplayAlerts = False

ActiveWindow.Close

Application.CutCopyMode = False
Application.DisplayAlerts = True

Windows("Mobile.xlsm").Activate
ActiveSheet.Paste
Range("A1").Select


'ActiveSheet.name = NewestFile.name
'Workbooks(NewestFile.Name).Close

End Sub

 

[mali10020]

Can soneone please help me!!

Thank you!

 

[johnnyL]

If you are getting an error when running the code please tell us which version of code that you are using, what line of code the error occurs on.

Please be specific on what issues you are having.