Option Explicit
Sub 文件压缩() '多个文件压在一起
Dim Rarexe As String
Dim myRAR As String
Dim Myfile As String
Dim FileString As String
Dim Result As Long
'Rarexe = "C:\program files\winrar\winrar.exe" 'rar程序路径'C:\Program Files\HaoZip\HaoZip.exe
Rarexe = "C:\Program Files\HaoZip\HaoZip.exe"
Myfile = ThisWorkbook.path & "\文件压缩.XLS" '指定要压缩的文件
myRAR = ThisWorkbook.path & "\B.rar" '压缩后的文件名