VBAで指定した画面を保存する方法を探していたらいいのがあった。
PrintScreenで取得してクリップボードからという手もいいんだけど、別のソフトが邪魔をするケースがあったので代案を探していた。
素晴らしい。同じものを探すのが大変なのでなくなる前に転記。
https://blog.systemjp.net/entry/2014/04/15/142736
'******************************************************************************
'* 【参考元】
'* Microsoft Support
'* 画面、フォーム、ウィンドウを取り込んで印刷する方法
'* 文書番号: 161299
'* http://support.microsoft.com/kb/161299/ja
'******************************************************************************
Option Explicit
Option Base 0
Private Type PALETTEENTRY
peRed As Byte
peGreen As Byte
peBlue As Byte
peFlags As Byte
End Type
Private Type LOGPALETTE
palVersion As Integer
palNumEntries As Integer
palPalEntry(255) As PALETTEENTRY ' Enough for 256 colors.
End Type
Private Type GUID
Data1 As Long
Data2 As Integer
Data3 As Integer
Data4(7) As Byte
End Type
Private Type RECT
Left As Long
Top As Long
Right As Long
Bottom As Long
End Type
Private Type PicBmp
Size As Long
Type As Long
hBmp As Long
hPal As Long
Reserved As Long
End Type
Private Const RASTERCAPS As Long = 38
Private Const RC_PALETTE As Long = &H100
Private Const SIZEPALETTE As Long = 104
Private Declare Function CreateCompatibleDC Lib "GDI32" (ByVal hDC As Long) As Long
Private Declare Function CreateCompatibleBitmap Lib "GDI32" (ByVal hDC As Long, ByVal nWidth As Long, ByVal nHeight As Long) As Long
Private Declare Function GetDeviceCaps Lib "GDI32" (ByVal hDC As Long, ByVal iCapabilitiy As Long) As Long
Private Declare Function GetSystemPaletteEntries Lib "GDI32" (ByVal hDC As Long, ByVal wStartIndex As Long, ByVal wNumEntries As Long, lpPaletteEntries As PALETTEENTRY) As Long
Private Declare Function CreatePalette Lib "GDI32" (lpLogPalette As LOGPALETTE) As Long
Private Declare Function SelectObject Lib "GDI32" (ByVal hDC As Long, ByVal hObject As Long) As Long
Private Declare Function BitBlt Lib "GDI32" (ByVal hDCDest As Long, ByVal XDest As Long, ByVal YDest As Long, ByVal nWidth As Long, ByVal nHeight As Long, ByVal hDCSrc As Long, ByVal XSrc As Long, ByVal YSrc As Long, ByVal dwRop As Long) As Long
Private Declare Function DeleteDC Lib "GDI32" (ByVal hDC As Long) As Long
Private Declare Function GetForegroundWindow Lib "user32" () As Long
Private Declare Function SelectPalette Lib "GDI32" (ByVal hDC As Long, ByVal hPalette As Long, ByVal bForceBackground As Long) As Long
Private Declare Function RealizePalette Lib "GDI32" (ByVal hDC As Long) As Long
Private Declare Function GetWindowDC Lib "user32" (ByVal hWnd As Long) As Long
Private Declare Function GetDC Lib "user32" (ByVal hWnd As Long) As Long
Private Declare Function GetWindowRect Lib "user32" (ByVal hWnd As Long, lpRect As RECT) As Long
Private Declare Function ReleaseDC Lib "user32" (ByVal hWnd As Long, ByVal hDC As Long) As Long
Private Declare Function GetDesktopWindow Lib "user32" () 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 vbPicTypeBitmap As Long = 1
Private Const vbSrcCopy As Long = &HCC0020
Private Const SM_CXSCREEN As Long = 0
Private Const SM_CYSCREEN As Long = 1
Private Declare Function GetSystemMetrics Lib "user32" (ByVal nIndex As Long) As Long
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'
' CreateBitmapPicture
' - Creates a bitmap type Picture object from a bitmap and
' palette.
'
' hBmp
' - Handle to a bitmap.
'
' hPal
' - Handle to a Palette.
' - Can be null if the bitmap doesn't use a palette.
'
' Returns
' - Returns a Picture object containing the bitmap.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Function CreateBitmapPicture(ByVal hBmp As Long, ByVal hPal As Long) As IPictureDisp
' Fill in with IDispatch Interface ID.
Dim IID_IDispatch As GUID
With IID_IDispatch
.Data1 = &H20400
.Data4(0) = &HC0
.Data4(7) = &H46
End With
' Fill Pic with necessary parts.
Dim Pic As PicBmp
With Pic
.Size = Len(Pic) ' Length of structure.
.Type = vbPicTypeBitmap ' Type of Picture (bitmap).
.hBmp = hBmp ' Handle to bitmap.
.hPal = hPal ' Handle to palette (may be null).
End With
' Create Picture object.
Dim IPic As IPicture
Dim r As Long
r = OleCreatePictureIndirect(Pic, IID_IDispatch, 1, IPic)
' Return the new Picture object.
Set CreateBitmapPicture = IPic
End Function
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'
' CaptureWindow
' - Captures any portion of a window.
'
' hWndSrc
' - Handle to the window to be captured.
'
' Client
' - If True CaptureWindow captures from the client area of the
' window.
' - If False CaptureWindow captures from the entire window.
'
' LeftSrc, TopSrc, WidthSrc, HeightSrc
' - Specify the portion of the window to capture.
' - Dimensions need to be specified in pixels.
'
' Returns
' - Returns a Picture object containing a bitmap of the specified
' portion of the window that was captured.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Function CaptureWindow(ByVal hWndSrc As Long, ByVal Client As Boolean, ByVal LeftSrc As Long, ByVal TopSrc As Long, ByVal WidthSrc As Long, ByVal HeightSrc As Long) As IPictureDisp
Dim r As Long
' Depending on the value of Client get the proper device context.
Dim hDCSrc As Long
hDCSrc = IIf(Client, GetDC(hWndSrc), GetWindowDC(hWndSrc))
' Create a memory device context for the copy process.
Dim hDCMemory As Long
hDCMemory = CreateCompatibleDC(hDCSrc)
' Create a bitmap and place it in the memory DC.
Dim hBmp As Long, hBmpPrev As Long
hBmp = CreateCompatibleBitmap(hDCSrc, WidthSrc, HeightSrc)
hBmpPrev = SelectObject(hDCMemory, hBmp)
' Get screen properties.
Dim RasterCapsScrn As Long, HasPaletteScrn As Long, PaletteSizeScrn As Long
RasterCapsScrn = GetDeviceCaps(hDCSrc, RASTERCAPS) ' Raster capabilities.
HasPaletteScrn = RasterCapsScrn And RC_PALETTE ' Palette support.
PaletteSizeScrn = GetDeviceCaps(hDCSrc, SIZEPALETTE) ' Size of palette.
' If the screen has a palette make a copy and realize it.
Dim hPal As Long, hPalPrev As Long, LogPal As LOGPALETTE
If HasPaletteScrn And (PaletteSizeScrn = 256) Then
' Create a copy of the system palette.
LogPal.palVersion = &H300
LogPal.palNumEntries = 256
r = GetSystemPaletteEntries(hDCSrc, 0, 256, LogPal.palPalEntry(0))
hPal = CreatePalette(LogPal)
' Select the new palette into the memory DC and realize it.
hPalPrev = SelectPalette(hDCMemory, hPal, 0)
r = RealizePalette(hDCMemory)
End If
' Copy the on-screen image into the memory DC.
r = BitBlt(hDCMemory, 0, 0, WidthSrc, HeightSrc, hDCSrc, LeftSrc, TopSrc, vbSrcCopy)
' Remove the new copy of the on-screen image.
hBmp = SelectObject(hDCMemory, hBmpPrev)
' If the screen has a palette get back the palette that was
' selected in previously.
If HasPaletteScrn And (PaletteSizeScrn = 256) Then
hPal = SelectPalette(hDCMemory, hPalPrev, 0)
End If
' Release the device context resources back to the system.
r = DeleteDC(hDCMemory)
r = ReleaseDC(hWndSrc, hDCSrc)
' Call CreateBitmapPicture to create a picture object from the
' bitmap and palette handles. Then return the resulting picture
' object.
Set CaptureWindow = CreateBitmapPicture(hBmp, hPal)
End Function
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'
' CaptureScreen
' - Captures the entire screen.
'
' Returns
' - Returns a Picture object containing a bitmap of the screen.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Function CaptureScreen() As IPictureDisp
' Get a handle to the desktop window.
Dim hWndScreen As Long
hWndScreen = GetDesktopWindow()
Dim cxScreen As Long, cyScreen As Long
cxScreen = GetSystemMetrics(SM_CXSCREEN)
cyScreen = GetSystemMetrics(SM_CYSCREEN)
' Call CaptureWindow to capture the entire desktop give the handle
' and return the resulting Picture object.
Set CaptureScreen = CaptureWindow(hWndScreen, False, 0, 0, cxScreen, cyScreen)
End Function
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
'
' CaptureActiveWindow
' - Captures the currently active window on the screen.
'
' Returns
' - Returns a Picture object containing a bitmap of the active
' window.
'''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''
Public Function CaptureActiveWindow() As IPictureDisp
Dim r As Long
' Get a handle to the active/foreground window.
Dim hWndActive As Long
hWndActive = GetForegroundWindow()
' Get the dimensions of the window.
Dim RectActive As RECT
r = GetWindowRect(hWndActive, RectActive)
' Call CaptureWindow to capture the active window given its
' handle and return the Resulting Picture object.
Set CaptureActiveWindow = CaptureWindow(hWndActive, False, 0, 0, RectActive.Right - RectActive.Left, RectActive.Bottom - RectActive.Top)
End Function
使用例１ ： 画面全体の画像をファイルに保存する
Public Sub SavePictureOfScreen()
Dim pic As IPictureDisp
Set pic = CaptureScreen()
Call SavePicture(pic, "C:\screen.bmp")
End Sub
使用例２ ： アクティブウィンドウの画像をファイルに保存する
※保存した画像の一部がおかしい不具合あり。原因は調査中。
Public Sub SavePictureOfActiveWindow()
Dim pic As IPictureDisp
Set pic = CaptureActiveWindow()
Call SavePicture(pic, "C:\activewindow.bmp")
End Sub
追記：
SavePictureOfActiveWindowでIEの画像を取ると画像が白くなってしまう不具合がある。ほかのサイトでも同じようなソースだったので何がおかしいのかよくわからない。ウィンドウハンドルの取り方？Sleepが必要？VB6のソースでは問題なさそうだった・・・。仕方ないので画像の加工で対応をしようかと思い、サンプルソースを探してきた。
https://plaza.rakuten.co.jp/tobiinsky/diary/200909160001/
'*****************************************************************************
'* トリミング処理
'*
'*****************************************************************************
Private Function fncPicTrimming(strPass As String, sglT As Single, sglB As Single, sglL As Single, sglR As Single) As String
Dim strWrkPass As String
fncPicTrimming = ""
Application.ScreenUpdating = False
'トリミング前保存場所
strWrkPass = ThisWorkbook.Path + "\image1.bmp"
'取得画像をそのまま処理すると画像がボケることがあるので、一度フォームに貼付→再保存する
UserForm1.Picture = LoadPicture(strPass)
SavePicture UserForm1.Picture, strWrkPass
UserForm1.Picture = LoadPicture()
'画像の挿入
ActiveSheet.Pictures.Insert(strWrkPass).Select
'トリミング実行 トリミングは実際に「マクロの記録」を利用して、その値をそのままコードへ（小数点をカットしないこと！）
Selection.ShapeRange.PictureFormat.CropTop = sglT
Selection.ShapeRange.PictureFormat.CropBottom = sglB
Selection.ShapeRange.PictureFormat.CropLeft = sglL
Selection.ShapeRange.PictureFormat.CropRight = sglR
'トリミング後保存場所
strWrkPass = ThisWorkbook.Path + "\image2.bmp"
'トリミング後の画像をクリップボードへコピーし、それを保存（excelではこれしか方法がなさそう）
Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap
SavePicture GetBitMap(), strWrkPass
Selection.Delete
Application.ScreenUpdating = True
fncPicTrimming = strWrkPass
End Function
0 件のコメント:
コメントを投稿