7,763
社区成员
发帖
与我相关
我的任务
分享
yesth01 = " D:\\yjm\\" & Format$(DateAdd("d", -1, Date), "yyyymmdd") & ".h01"
yestm01 = " D:\\yjm\\" & Format$(DateAdd("d", -1, Date), "yyyymmdd") & ".m01"
yesth04 = " D:\\yjm\\" & Format$(DateAdd("d", -1, Date), "yyyymmdd") & ".h04"
yestm04 = " D:\\yjm\\" & Format$(DateAdd("d", -1, Date), "yyyymmdd") & ".m04"
rarname = Mid(Format(Now, "YYYYMMDD"), 1) & "QZ05A"
s = "C:\Program Files\WinRAR\WinRAR.exe "
s = s & "a d:\\yjm\\" & rarname & ".rar "
'将昨日四个数据文件添加至压缩文件内
s = s & yesth01 '添加昨天的H01文件
s = s & yestm01 '添加昨天的M01文件
s = s & yesth04 '添加昨天的H04文件
s = s & yestm04 '添加昨天的M04文件
Shell s '调用压缩文件,将昨日四个文件压缩
s = s & "a -ep d:\\yjm\\" & rarname & ".rar "
yesth01 = Format$(DateAdd("d", -1, Date), "yyyymmdd") & ".h01"
yestm01 = Format$(DateAdd("d", -1, Date), "yyyymmdd") & ".m01"
yesth04 = Format$(DateAdd("d", -1, Date), "yyyymmdd") & ".h04"
yestm04 = Format$(DateAdd("d", -1, Date), "yyyymmdd") & ".m04"
rarname = Mid(Format(Now, "YYYYMMDD"), 1) & "QZ05A"
ChDir "d:\yjm\"
s = "C:\Program Files\WinRAR\WinRAR.exe "
s = s & "a d:" & rarname & ".rar "
'将昨日四个数据文件添加至压缩文件内
s = s & yesth01 '添加昨天的H01文件
s = s & yestm01 '添加昨天的M01文件
s = s & yesth04 '添加昨天的H04文件
s = s & yestm04 '添加昨天的M04文件
Shell s '调用压缩文件,将昨日四个文件压缩