摘要: Public Sub Basic_CodeFrame() AppSettings 'On Error GoTo ErrHandler Dim StartTime, UsedTime As Variant StartTime = VBA.Timer 'Input code here Dim Wb As Workbook Dim Sht As... 阅读全文
posted @ 2017-07-06 23:46 wangway 阅读(353) 评论(0) 推荐(0) 编辑
摘要: Public Sub GatherDataPicker() Application.ScreenUpdating = False Application.DisplayAlerts = False Application.Calculation = xlCalculationManual Application.StatusBar = ">>>>>>>>程序正在运... 阅读全文
posted @ 2017-07-06 23:42 wangway 阅读(165) 评论(0) 推荐(0) 编辑
摘要: Private Type GUID Data1 As Long Data2 As Integer Data3 As Integer Data4(0 To 7) As Byte End Type Private Type GdiplusStartupInput GdiplusVersion As Long DebugEventCallback As ... 阅读全文
posted @ 2017-07-06 23:34 wangway 阅读(320) 评论(0) 推荐(0) 编辑
摘要: Public Sub GetContents() Dim Reg As Object Dim Matches As Object Dim OneMatch As Object Dim Index As Long Dim TimeStart As Variant TimeStart = VBA.Timer Set Reg = CreateOb... 阅读全文
posted @ 2017-07-06 23:32 wangway 阅读(782) 评论(0) 推荐(0) 编辑
摘要: Sub 获取OutLook收件箱主题和正文() On Error Resume Next Dim sht As Worksheet Dim olApp As Outlook.Application Dim olMail As Outlook.MailItem Dim olNameSpace As Outlook.Namespace Dim OneF... 阅读全文
posted @ 2017-07-06 20:47 wangway 阅读(1547) 评论(0) 推荐(0) 编辑
摘要: Public Sub NextSeven_CodeFrame() Application.ScreenUpdating = False Application.DisplayAlerts = False Application.Calculation = xlCalculationManual Application.StatusBar = ">>>>>>>>程序... 阅读全文
posted @ 2017-07-06 20:33 wangway 阅读(1394) 评论(0) 推荐(0) 编辑
摘要: Sub NextSeven_CodeFrame() Application.ScreenUpdating = False Application.DisplayAlerts = False Application.Calculation = xlCalculationManual Application.StatusBar = ">>>>>>>>程序正在运行>>>... 阅读全文
posted @ 2017-07-06 20:24 wangway 阅读(556) 评论(0) 推荐(0) 编辑
摘要: Public Sub GatherDataPicker() Application.ScreenUpdating = False Application.DisplayAlerts = False Application.Calculation = xlCalculationManual Application.StatusBar = ">>>>>>>>程序正在运... 阅读全文
posted @ 2017-07-06 20:14 wangway 阅读(102) 评论(0) 推荐(0) 编辑
摘要: Public Sub StartRecursionFolder() Dim Pre As Presentation Dim FolderPath As String Dim pp As String Dim id As String Dim oFileDialog As FileDialog Set oFileDialog = Applicatio... 阅读全文
posted @ 2017-07-06 15:36 wangway 阅读(1538) 评论(0) 推荐(0) 编辑
摘要: Sub NextSeven20170706001() Application.ScreenUpdating = False Application.DisplayAlerts = False Application.Calculation = xlCalculationManual Application.StatusBar = ">>>>>>>>程序正在运行>>... 阅读全文
posted @ 2017-07-06 14:09 wangway 阅读(204) 评论(0) 推荐(0) 编辑