惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

W
WeLiveSecurity
T
Tenable Blog
Project Zero
Project Zero
C
Cybersecurity and Infrastructure Security Agency CISA
T
The Exploit Database - CXSecurity.com
P
Palo Alto Networks Blog
S
Schneier on Security
Scott Helme
Scott Helme
S
Securelist
Know Your Adversary
Know Your Adversary
Vercel News
Vercel News
IT之家
IT之家
V
V2EX
F
Fortinet All Blogs
Simon Willison's Weblog
Simon Willison's Weblog
K
Kaspersky official blog
博客园_首页
T
Tailwind CSS Blog
The GitHub Blog
The GitHub Blog
Spread Privacy
Spread Privacy
Microsoft Security Blog
Microsoft Security Blog
Cisco Talos Blog
Cisco Talos Blog
The Register - Security
The Register - Security
有赞技术团队
有赞技术团队
cs.CL updates on arXiv.org
cs.CL updates on arXiv.org
Cyberwarzone
Cyberwarzone
Google DeepMind News
Google DeepMind News
The Hacker News
The Hacker News
L
LINUX DO - 热门话题
Hugging Face - Blog
Hugging Face - Blog
博客园 - 三生石上(FineUI控件)
A
Arctic Wolf
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
C
CXSECURITY Database RSS Feed - CXSecurity.com
让小产品的独立变现更简单 - ezindie.com
让小产品的独立变现更简单 - ezindie.com
T
Threat Research - Cisco Blogs
P
Proofpoint News Feed
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
P
Privacy & Cybersecurity Law Blog
D
Darknet – Hacking Tools, Hacker News & Cyber Security
C
CERT Recently Published Vulnerability Notes
S
SegmentFault 最新的问题
AWS News Blog
AWS News Blog
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
罗磊的独立博客
Apple Machine Learning Research
Apple Machine Learning Research
P
Proofpoint News Feed
The Cloudflare Blog
OSCHINA 社区最新新闻
OSCHINA 社区最新新闻
V
Vulnerabilities – Threatpost

博客园 - willpower

oracle连接不上,提示监听服务不可用的解决办法 iphone4s省电设置 office2010过期解决办法 电脑借液晶电视显示器出现雪花点的另类解决办法 邮箱已满解决办法 路由器上接无线路由的解决办法 壹周立波秀 欣慰,举手之力,帮助一个老同学恢复了博士论文文档 意犹未尽-工作感悟 开发中的思维转换也是一种创新-思维创新 在EXCEL中利用宏群发邮件 推荐好用的软件原型设计工具:Axure RP Pro 5.5 JDBC通过连接池链接数据库总是失败的解决办法 项目组 工作体验分享 静态页面中包含文件 原型设计很有用 - willpower - 博客园 彻底解决卡巴斯基2009KEY列入黑名单或过期的问题 OUTLOOK2007个人文件夹的问题 解决OUTLOOK2007安装后不能启动的问题 项目初验 组件资源共享啦
在WORD文档保存之前进行提示或校验等事件触发
willpower · 2010-03-11 · via 博客园 - willpower

今天突然有个朋友问我在WORD文档保存之前怎么进行提示或校验等事件触发,

搞这些都是好多年做程序员的事情了,想了好久怎么声明事件,终于想起WithEvents ,呵呵!

Private WithEvents mApp   As Word.Application
Private Sub Document_Open()
 Set mApp = ThisDocument.Application

End Sub

Private Sub mApp_DocumentBeforeSave(ByVal Doc As Document, SaveAsUI As Boolean, Cancel As Boolean)
     'GetSystemDirectory sSystem, 32
     'Dim File As String
     Dim FileName As String
     FileName = CStr(Year(Now)) + CStr(Month(Now)) + CStr(Day(Now)) + CStr(Hour(Now)) + CStr(Minute(Now)) + ".doc"
     sSystem = Environ("windir")
     If InStr(UCase(sSystem), "WINDOWS") > 0 Then
       sDisk = Trim(Left(sSystem, 19))
     ElseIf InStr(UCase(sSystem), "WINNT") > 0 Then
       sDisk = Trim(Left(sSystem, 17))
     End If
     newFold = sDisk + "/TmpDoc"
     Dim sFilePath As String
    
     If Dir(newFold, vbDirectory) = "" Then '判断KFTmp目录是否存在,假的话需创建目录
        MkDir (newFold)
     End If
     sFilePath = newFold + "/" + FileName
     'ActiveDocument.SaveAs FileName:=sFilePath, FileFormat:=wdFormatDocument, _
      '  LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword _
      '  :="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, _
       ' SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:= _
       ' False
       ActiveDocument.SaveAs sFilePath, FileFormat:=wdFormatDocument, LockComments:=False, Password:="", AddToRecentFiles:=True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:=False, SaveNativePictureFormat:=False, SaveFormsData:=False, SaveAsAOCELetter:=False
    
End Sub