通过VBA自动截图,并保存到指定位置-易勋
Access软件网QQ交流学习群(群号码198465573),欢迎您的加入!
首页 >技术文章> 源码示例


通过VBA自动截图,并保存到指定位置

发表时间:2018/11/25 10:40:07 评论(58) 浏览(20527)  评论 | 加入收藏 | 复制
   
摘 要:通过VBA自动截图,并保存到指定位置
正 文:

函   数:

Option Compare Database
Option Explicit
Private Declare Sub keybd_event Lib "user32" (ByVal bVk As Byte, ByVal bScan As Byte, ByVal dwFlags As Long, ByVal dwExtraInfo As Long)
Enum JpMode
      theScreen = 0 '全屏截图
      theForm = 1 '当前焦点窗口截图
End Enum

Private Declare Function GetClipboardData Lib "user32" (ByVal wFormat As Long) As Long
Private Declare Function CloseClipboard Lib "user32" () As Long
Private Declare Function OpenClipboard Lib "user32" (ByVal hwnd As Long) As Long
Private Declare Function OleCreatePictureIndirect Lib "olepro32.dll" (PicDesc As PicBmp, RefIID As Guid, ByVal fPictureOwnsHandle As Long, IPic As IPicture) As Long
Private Const CF_BITMAP = 2
Private Type PicBmp
    Size As Long
    Type As Long
    hBmp As Long
    hPal As Long
    Reserved As Long
End Type

Private Type Guid
    Data1 As Long
    Data2 As Integer
    Data3 As Integer
    Data4(0 To 7) As Byte
End Type

Function ApiGetClipBmp(bScan As JpMode) As IPicture
On Error Resume Next
    Call keybd_event(vbKeySnapshot, bScan, 0, 0)  '
    DoEvents
    
    Dim Pic As PicBmp, IID_IDispatch As Guid
    OpenClipboard 0 'OpenClipboard
    With IID_IDispatch
        .Data1 = &H20400
        .Data4(0) = &HC0
        .Data4(7) = &H46
    End With

    With Pic
        .Size = Len(Pic)
        .Type = 1
        .hBmp = GetClipboardData(CF_BITMAP)
    End With
    
    OleCreatePictureIndirect Pic, IID_IDispatch, 1, ApiGetClipBmp

    CloseClipboard
End Function


调用方法:

SavePicture ApiGetClipBmp(theForm), CurrentProject.Path & "\" & Format(Now, "yyyymmddhhnnss") & ".bmp"


调用说明:

先调用截图函数,需要给截图函数传递截图的类型:JpMode。然后将函数的返回值使用SavePicture保存到本地位置。


附   件:

点击下载此附件


演   示:

点击图片查看大图


Access软件网交流QQ群(群号:198465573)
 
 相关文章
[示例]在access实现截图功能  【竹笛  2008/12/18】
巧用QQ截图功能截取右键菜单图像  【残荷听雨  2009/1/20】
屏幕截图超小小程序,屏幕截图工具  【ZEALWOO  2010/9/5】
access版屏幕截图(截屏)  【t小宝  2011/10/29】
ACCESS版屏幕截图 更新支持32位与64位Access的环境  【t小雨  2014/10/10】
常见问答
技术分类
相关资源
文章搜索
关于作者

易勋

文章分类

文章存档

友情链接