クリップボードの制御：テキストデータをセットする
概要および目的 計算結果や検索結果を、他のアプリに貼り付けて利用する場合、VBAのプログラムから、クリップボードにデータ（テキスト）をセット（コピー）します。 データは、他のアプリで貼り付けることができます。 Option Compare Database Option Explicit #If VBA7 Then Private Declare PtrSafe Function GlobalUnlock Lib "kernel32" (ByVal hMem As LongPtr) As Long #Else Private Declare Function GlobalUnlock Lib "kernel32" (ByVal hMem As Long) As Long #End If #If VBA7 Then Private Declare PtrSafe Function GlobalLock Lib "kernel32" (ByVal hMem As LongPtr) As LongPtr #Else Private Declare Function GlobalLock Lib "kernel32" (ByVal hMem As Long) As Long #End If #If VBA7 Then Private Declare PtrSafe Function GlobalAlloc Lib "kernel32" (ByVal wFlags As Long, ByVal dwBytes As LongPtr) As LongPtr #Else Private Declare Function GlobalAlloc Lib "kernel32" (ByVal wFlags As Long, ByVal dwBytes As Long) As Long #End If #If VBA7 Then Private Declare PtrSafe Function CloseClipboard Lib "User32" () As Long #Else Private Declare Function CloseC...