{"id":6042,"date":"2021-06-16T18:04:16","date_gmt":"2021-06-16T09:04:16","guid":{"rendered":"https:\/\/kats-eye.net\/info\/?p=6042"},"modified":"2021-06-16T18:05:36","modified_gmt":"2021-06-16T09:05:36","slug":"vba-sendmessage","status":"publish","type":"post","link":"https:\/\/kats-eye.net\/info\/2021\/06\/16\/vba-sendmessage\/","title":{"rendered":"\u30a8\u30af\u30bb\u30eb VBA\u3067 VS\u30d5\u30a9\u30fc\u30e0\u30a2\u30d7\u30ea\u64cd\u4f5c"},"content":{"rendered":"\n<h2>\u6982\u8981<\/h2>\n\n\n\n<p>\u3000\u30a8\u30af\u30bb\u30ebVBA\u304b\u3089\u3001Visual Studio \u30d5\u30a9\u30fc\u30e0\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u64cd\u4f5c\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002<\/p>\n\n\n\n<p>\u3000\u6b21\u306e\u52d5\u753b\u3067\u306f\u3001\u30a8\u30af\u30bb\u30ebVBA\u304b\u3089\u3001C#\u30d5\u30a9\u30fc\u30e0\u306e\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u51e6\u7406 \u3068 \u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u30fb\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306e\u5185\u5bb9\u3092\u78ba\u8a8d\u3001\u5909\u66f4\u3059\u308b\u51e6\u7406\u306e\u78ba\u8a8d\u3092\u884c\u3063\u3066\u3044\u307e\u3059\u3002<br>\u3000\u30a8\u30af\u30bb\u30eb\u30b7\u30fc\u30c8\u3068C#\u30d5\u30a9\u30fc\u30e0\u4e0a\u306e\u540c\u3058\u756a\u53f7\u306e\u30dc\u30bf\u30f3\u306f\u3001\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u540c\u3058\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u51fa\u529b\u3057\u307e\u3059\u3002\u3053\u308c\u306f\u3001\u30a8\u30af\u30bb\u30ebVBA\u5074\u304b\u3089\u3001C#\u30d5\u30a9\u30fc\u30e0\u30dc\u30bf\u30f3\u306e\u30af\u30ea\u30c3\u30af\u306b\u76f8\u5f53\u3059\u308b\u64cd\u4f5c\u3092\u884c\u3063\u3066\u3044\u308b\u305f\u3081\u3067\u3059\u3002<br>\u3000\u6b21\u306b\u30a8\u30af\u30bb\u30eb\u30b7\u30fc\u30c8\u306e \u201cForm\u306e\u5024\u3092\u53d6\u5f97\u201d \u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u3068\u3001VBA\u5074\u304b\u3089C#\u30d5\u30a9\u30fc\u30e0\u5074\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306e\u8a2d\u5b9a\u5185\u5bb9\u3092\u78ba\u8a8d\u3057\u3001\u4ea4\u4e92\u306b\u6587\u5b57\u3092\u5165\u308c\u66ff\u3048\u307e\u3059\u3002\u540c\u69d8\u306b\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\uff12\u3082\u201c\u30c1\u30a7\u30c3\u30af\u201d\uff0f\u201c\u672a\u30c1\u30a7\u30c3\u30af\u201d \u72b6\u614b\u3092\u4ea4\u4e92\u306b\u5165\u308c\u66ff\u3048\u3066\u3044\u307e\u3059\u3002\u8aad\u307f\u8fbc\u3093\u3060 C#\u30d5\u30a9\u30fc\u30e0\u306e\u5024\u306f\u3001\u30a8\u30af\u30bb\u30eb\u30b7\u30fc\u30c8\u306b\u8868\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-video\"><video controls src=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2021\/06\/20210614.mp4\"><\/video><figcaption>\u3000\u3000<br><\/figcaption><\/figure>\n\n\n\n<h2>\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u306b\u3088\u308b\u64cd\u4f5c<\/h2>\n\n\n\n<h3>(1) \u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u306b\u3064\u3044\u3066<\/h3>\n\n\n\n<p>    \u201c\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u201d \u306a\u308b\u5404\u30a6\u30a3\u30f3\u30c9\u30a6\u306b\u5272\u308a\u632f\u3089\u308c\u305f\u7ba1\u7406\u756a\u53f7\u3092\u7528\u3044\u3066\u5404\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u64cd\u4f5c\u3057\u307e\u3059\u3002<br>\u3000\u4eca\u56de\u306eC#\u30d5\u30a9\u30fc\u30e0\u30a2\u30d7\u30ea\u306e\u5834\u5408\u3001\u6b21\u306e\u56f3\u306e\u8d64\u304f\u30de\u30fc\u30ad\u30f3\u30b0\u3057\u305f\u7b87\u6240\u306e\u69d8\u306b\u30d5\u30a9\u30fc\u30e0\u3001\u30dc\u30bf\u30f3\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9 \u7b49\u306b\u306f\u3001\u305d\u308c\u305e\u308c\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\uff08\u30bf\u30a4\u30c8\u30eb\uff1f\uff09\u304c\u3064\u3044\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u3092\u624b\u639b\u304b\u308a\u306b\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u3092\u898b\u3064\u3051\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"357\" height=\"307\" src=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2021\/06\/003-2.jpg\" alt=\"\" class=\"wp-image-6056\" srcset=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2021\/06\/003-2.jpg 357w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2021\/06\/003-2-300x258.jpg 300w\" sizes=\"(max-width: 357px) 100vw, 357px\" \/><figcaption>\u3000\u3000\u3000<\/figcaption><\/figure><\/div>\n\n\n\n<p>\u3000\u201cSpy++\u201d \u3068\u3044\u3046\u30bd\u30d5\u30c8\u3092\u4f7f\u7528\u3057\u3066\u3001\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u304c\u3069\u306e\u69d8\u306b\u5272\u308a\u632f\u3089\u308c\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3057\u307e\u3059\u3002\u79c1\u306e\u5834\u5408\u3001Microsoft Visual Studio Community 2019 \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u307e\u3059\u304c\u3001\u6b21\u306e\u56f3\u306e\u901a\u308a\u3001MENU\u30d0\u30fc\u304b\u3089\u8d77\u52d5\u3059\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" src=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2021\/06\/\u30ad\u30e3\u30d7\u30c1\u30e3.jpg\" alt=\"\" class=\"wp-image-6062\" width=\"371\" height=\"415\" srcset=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2021\/06\/\u30ad\u30e3\u30d7\u30c1\u30e3.jpg 414w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2021\/06\/\u30ad\u30e3\u30d7\u30c1\u30e3-268x300.jpg 268w\" sizes=\"(max-width: 371px) 100vw, 371px\" \/><figcaption>\u3000<\/figcaption><\/figure><\/div>\n\n\n\n<p>\u3000\u201cSpy++\u201d \u3092\u8d77\u52d5\u3059\u308b\u3068\u3001\u305f\u304f\u3055\u3093\u30a6\u30a3\u30f3\u30c9\u30a6\u304c\u3042\u308b\u306e\u3067\u3001\u63a2\u3059\u5fc5\u8981\u306f\u3042\u308a\u307e\u3059\u304c\u3001C#\u30d5\u30a9\u30fc\u30e0\u30a2\u30d7\u30ea\u304c\u52d5\u4f5c\u3057\u3066\u3044\u308b\u5834\u5408\u3001\u30c8\u30c3\u30d7\u30ec\u30d9\u30eb\u306e\u968e\u5c64\u306b \u201cVBA_TEST\u201d \u3068\u3044\u3046\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u898b\u3064\u3051\u308b\u3053\u3068\u304c\u51fa\u6765\u307e\u3059\u3002\u4e0b\u4f4d\u306e\u968e\u5c64\u3092\u5c55\u958b\u3059\u308b\u3068\u6b21\u306e\u56f3\u306e\u69d8\u306b\u3001\u30dc\u30bf\u30f3\u7b49\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u3082\u78ba\u8a8d\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\u3002\u8d64\u8272\u3067\u30de\u30fc\u30af\u3057\u305f\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u306e\u524d\u306b\u9752\u8272\u3067\u30de\u30fc\u30af\u3057\u305f\uff11\uff16\u9032\u6570\u306e\u5024\u304c\u3001\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u306b\u306a\u308a\u307e\u3059\u3002<br>\u3000\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u306f\u30d7\u30ed\u30b0\u30e9\u30e0\u8d77\u52d5\u6642\u306b\u5272\u308a\u632f\u3089\u308c\u308b\u306e\u3067\u3001\u5916\u90e8\u64cd\u4f5c\u306b\u5229\u7528\u3059\u308b\u5834\u5408\u306f\u6700\u65b0\u306e\u5024\u3092\u78ba\u8a8d\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img loading=\"lazy\" width=\"627\" height=\"374\" src=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2021\/06\/004-1.jpg\" alt=\"\" class=\"wp-image-6057\" srcset=\"https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2021\/06\/004-1.jpg 627w, https:\/\/kats-eye.net\/info\/wp-content\/uploads\/2021\/06\/004-1-300x179.jpg 300w\" sizes=\"(max-width: 627px) 100vw, 627px\" \/><figcaption>\u3000\u3000\u3000<br><\/figcaption><\/figure><\/div>\n\n\n\n<h3>(2) Win32 API \u95a2\u6570<\/h3>\n\n\n\n<p>\u3000\u5b9f\u969b\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u306f\u3001Win32 API \u3092\u7528\u3044\u3066\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u3092\u53d6\u5f97\u30fb\u64cd\u4f5c\u3057\u307e\u3059\u3002\u4eca\u56de\u3001\u4f7f\u7528\u3057\u3066\u3044\u308b\u95a2\u6570\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h5>\u2460 FindWindow<\/h5>\n\n\n\n<p>\u3000\u6307\u5b9a\u3059\u308b\u30af\u30e9\u30b9\u540d\u30fb\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u3092\u6301\u3064\u30c8\u30c3\u30d7\u30ec\u30d9\u30eb\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u3092\u8fd4\u3057\u307e\u3059\u3002C#\u30d5\u30a9\u30fc\u30e0\u30a2\u30d7\u30ea\uff08 VBA_TEST\uff09\u3092\u4e00\u756a\u6700\u521d\u306b\u691c\u7d22\u3059\u308b\u6642\u306b\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"wp-block-columns\">\n<div class=\"wp-block-column\" style=\"flex-basis:100%\">\n<p>\u3010\u5ba3\u8a00\u3011<br>Declare Function FindWindow Lib &#8220;user32&#8221; Alias &#8220;FindWindowA&#8221; \u3000\u3000\u3000\u3000(ByVal lpClassName As String, ByVal lpWindowName As String) \u3000\u3000\u3000\u3000As Long<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><tbody><tr><td>pClassName<\/td><td>\u30a6\u30a3\u30f3\u30c9\u30a6\u30af\u30e9\u30b9\u540d\u3092\u6307\u5b9a<\/td><\/tr><tr><td>lpWindowName<\/td><td>\u30a6\u30a3\u30f3\u30c9\u30a6\u30bf\u30a4\u30c8\u30eb\u3092\u6307\u5b9a<\/td><\/tr><tr><td>\u623b\u308a\u5024<\/td><td>\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u3092\u8fd4\u3059<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u3010\u4f7f\u7528\u4f8b\u3011\u30af\u30e9\u30b9\u540d\u304c\u4e0d\u660e\u3067\u3001\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u306f\u5224\u3063\u3066\u3044\u308b\u5834\u5408\u3002<br>Dim hWnd As Long<br>hWnd = FindWindow(vbNullString, \u201c\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u201d)<\/p>\n\n\n\n<h5>\u2461 FindWindowEx<\/h5>\n\n\n\n<p>\u3000\u89aa\u30cf\u30f3\u30c9\u30eb\u30fb\u30af\u30e9\u30b9\u540d\u30fb\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u304b\u3089\u5b50\u30cf\u30f3\u30c9\u30eb\u3092\u63a2\u3057\u307e\u3059\u3002button \u7b49\u3001\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u304c\u5909\u308f\u3089\u306a\u3044\u5834\u5408\u306f\u691c\u7d22\u3057\u3084\u3059\u3044\u3067\u3059\u304c\u3001\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u7b49\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u304c\u5909\u308f\u308b\u5834\u5408\u306e\u691c\u7d22\u306f\u4e0d\u5411\u304d\u3068\u601d\u3044\u307e\u3059\u3002\uff08\u4f7f\u3048\u308b\uff1f\uff09<\/p>\n\n\n\n<p>\u3010\u5ba3\u8a00\u3011<br>Declare Function FindWindowEx Lib &#8220;user32.dll&#8221; Alias &#8220;FindWindowExA&#8221; _<br>(ByVal hwndParent As Long, ByVal hwndChildAfter As Long, _<br>ByVal lpszClass As String, ByVal lpszWindow As String) As Long<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><tbody><tr><td>hwndParent<\/td><td>\u89aa\u30cf\u30f3\u30c9\u30eb\u6307\u5b9a<\/td><\/tr><tr><td>hwndChildAfter<\/td><td>\u540c\u540d\u30af\u30e9\u30b9\u30fb\u30bf\u30a4\u30c8\u30eb\u306e\u30cf\u30f3\u30c9\u30eb\u691c\u7d22\u6642\u3001\u201c0\u201d \u6307\u5b9a\u3067\u3001Z\u30aa\u30fc\u30c0\u30fc\u6700\u521d\u306e\u30cf\u30f3\u30c9\u30eb\u306e\u307f\u691c\u7d22\u3002<br>Z\u30aa\u30fc\u30c0\u30fc\u6307\u5b9a\u3067\u4ed6\u540c\u540d\u30cf\u30f3\u30c9\u30eb\u3082\u691c\u7d22\u3002<\/td><\/tr><tr><td>lpszClass<\/td><td>\u30a6\u30a3\u30f3\u30c9\u30a6\u30af\u30e9\u30b9\u540d\u3092\u6307\u5b9a<\/td><\/tr><tr><td>lpszWindow<\/td><td>\u30a6\u30a3\u30f3\u30c9\u30a6\u30bf\u30a4\u30c8\u30eb\u3092\u6307\u5b9a<\/td><\/tr><tr><td>\u623b\u308a\u5024<\/td><td>\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u3092\u8fd4\u3059<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u3010\u4f7f\u7528\u4f8b\u3011\u30af\u30e9\u30b9\u540d\u304c\u4e0d\u660e\u3067\u3001\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u306f\u5224\u3063\u3066\u3044\u308b\u5834\u5408\u3002<br>Dim hWnd As Long<br>hWnd = FindWindowEx ( hParent , 0,  vbNullString ,  &#8220;button1&#8221; );<\/p>\n\n\n\n<h5>\u2462 GetWindow<\/h5>\n\n\n\n<p>\u3000\u30a6\u30a3\u30f3\u30c9\u30a6\u3068\u95a2\u4fc2\uff08Z\u30aa\u30fc\u30c0\u30fc\u7b49\uff09\u3092\u6307\u5b9a\u3057\u3001\u691c\u7d22\u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u30cf\u30f3\u30c9\u30eb\u3092\u8fd4\u3057\u307e\u3059\u3002\u201cSpy++\u201d \u7b49\u3067\u4e88\u3081\u30a6\u30a3\u30f3\u30c9\u30a6\u69cb\u6210\u3092\u628a\u63e1\u3057\u3066\u3044\u308c\u3070\u3001\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u304c\u5909\u308f\u308b\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u7b49\u3067\u3082\u3001\u5bfe\u8c61\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u691c\u7d22\u3067\u304d\u308b\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3010\u5ba3\u8a00\u3011<br>Declare Function GetWindow Lib &#8220;user32&#8221; Alias &#8220;GetWindow&#8221; (ByVal hwnd As Long, ByVal wCmd As Long) As Long<\/p>\n<\/div>\n<\/div>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><tbody><tr><td>hwnd<\/td><td>&nbsp;\u57fa\u6e96\u3068\u306a\u308b\u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u30cf\u30f3\u30c9\u30eb\u3092\u6307\u5b9a<\/td><\/tr><tr><td>wCmd<\/td><td>\u6b21\u306e\u4f8b\u306e\u901a\u308a\u3001\u57fa\u6e96\u30a6\u30a3\u30f3\u30c9\u30a6\u306b\u5bfe\u3059\u308b\u95a2\u4fc2\u6307\u5b9a<br>GW_CHILD\u3000\u3000\u3000 \uff1a \u5b50\u30a6\u30a3\u30f3\u30c9\u30a6<br>GW_HWNDNEXT \uff1a \u6b21\u30a6\u30a3\u30f3\u30c9\u30a6<br>GW_HWNDPREV \uff1a \u524d\u30a6\u30a3\u30f3\u30c9\u30a6<\/td><\/tr><tr><td>\u623b\u308a\u5024<\/td><td>\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u3092\u8fd4\u3059<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>\u3010\u4f7f\u7528\u4f8b\u3011<br>Dim hWnd As Long<br>hWnd = GetWindow ( myHwnd , GW_HWNDNEXT )<\/p>\n\n\n\n<h5>\u2463 SendMessage \u3001SendMessageStr<\/h5>\n\n\n\n<p>\u3000\u30a6\u30a3\u30f3\u30c9\u30a6\u3078\u3001\u6307\u5b9a\u3055\u308c\u305f\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u9001\u4fe1\u3057\u307e\u3059\u3002button \u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u6642\u3001\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u306e\u5024\u3092\u8a2d\u5b9a\u3059\u308b\u6642\u3084\u3001\u53cd\u5bfe\u306b\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u3092\u53d6\u5f97\u3059\u308b\u6642\u306a\u3069\u306b\u3082\u4f7f\u7528\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3010\u5ba3\u8a00\u3011<br>Declare Function SendMessage Lib &#8220;user32&#8221; Alias &#8220;SendMessageA&#8221; (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, lParam As Any) As Long<\/p>\n\n\n\n<p>Declare Function SendMessageStr Lib &#8220;user32.dll&#8221; Alias &#8220;SendMessageA&#8221; (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParam As String) As Long<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><tbody><tr><td>hwnd<\/td><td>\u30e1\u30c3\u30bb\u30fc\u30b8\u9001\u308a\u5148\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u3092\u6307\u5b9a<\/td><\/tr><tr><td>wMsg<\/td><td>\u30e1\u30c3\u30bb\u30fc\u30b8 \u30b3\u30fc\u30c9\u6307\u5b9a<\/td><\/tr><tr><td>wParam<\/td><td>\u30e1\u30c3\u30bb\u30fc\u30b8\u4ed8\u52a0\u60c5\u5831\u6307\u5b9a<\/td><\/tr><tr><td>lParam<\/td><td>\u30e1\u30c3\u30bb\u30fc\u30b8\u4ed8\u52a0\u60c5\u5831\u6307\u5b9a<\/td><\/tr><tr><td>\u623b\u308a\u5024<\/td><td>\u51e6\u7406\u7d50\u679c\u3092\u8fd4\u3059\u3002<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<h5>\u2464 SetForegroundWindow<\/h5>\n\n\n\n<p>\u3000\u6307\u5b9a\u30cf\u30f3\u30c9\u30eb\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u6700\u524d\u9762\u306b\u30a2\u30af\u30c6\u30a3\u30d6\u5316\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3010\u5ba3\u8a00\u3011<br>Declare Sub SetForegroundWindow Lib &#8220;user32.dll&#8221; (ByVal ms As Long)<br><br><br><\/p>\n\n\n\n<h2>\u30d7\u30ed\u30b0\u30e9\u30e0<\/h2>\n\n\n\n<h3>(1) C#\u30d5\u30a9\u30fc\u30e0\u30a2\u30d7\u30ea<\/h3>\n\n\n\n<p>\u3000\u540c\u4e00\u30a2\u30d7\u30ea\u5185\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u69cb\u6210\uff08\u9806\u756a\uff09\u306f\u3001Z\u30aa\u30fc\u30c0\u30fc\u306b\u3088\u3063\u3066\u78ba\u5b9a\u3059\u308b\u69d8\u3067\u3059\u3002Z\u30aa\u30fc\u30c0\u30fc\u306f\u30d5\u30a9\u30fc\u30e0\u306b\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3092\u8ffd\u52a0\u3057\u305f\u9806\u756a\u306e\u69d8\u3067\u3059\u3002\u78ba\u8a8d\u3057\u306a\u304c\u3089\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4f5c\u6210\u3059\u308b\u70ba\u3001\u5f8c\u304b\u3089\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3092\u8ffd\u52a0\u3059\u308b\u3068\u30a6\u30a3\u30f3\u30c9\u30a6\u69cb\u6210\uff08\u9806\u756a\uff09\u304c\u5909\u5316\u3057\u3001\u30a8\u30af\u30bb\u30ebVBA\u5074\u3067\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u4fee\u6b63\u304c\u5fc5\u8981\u3068\u306a\u308a\u307e\u3057\u305f\u3002\u884c\u756a\uff12\uff14\uff5e\uff13\uff12\u3067\u306f\u3001C#\u30d7\u30ed\u30b0\u30e9\u30e0\u3067\u64cd\u4f5c\u5bfe\u8c61\u3068\u306a\u308b\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u3092\u6700\u524d\u9762\u306b\u79fb\u52d5\u3057\u3001\u30a6\u30a3\u30f3\u30c9\u30a6\u69cb\u6210\uff08\u9806\u756a\uff09\u3092\u4e00\u5b9a\u306b\u3057\u3066\u3044\u307e\u3059\u3002\u3053\u306e\u69d8\u306b\u3059\u308b\u3053\u3068\u3067\u3001\u30a8\u30af\u30bb\u30ebVBA\u5074\u3067\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u5909\u66f4\u3092\u4e0d\u8981\u306b\u3057\u3066\u3044\u307e\u3059\u3002<br>\u3000\u884c\u756a35\uff5e44\uff0c\u884c\u756a46\uff5e56 \u3067\u306f\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306e\u5024\u304c\u5909\u308f\u308b\u969b\u306b\u3001C#\u5074\u3067\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\uff08\u30c6\u30ad\u30b9\u30c8\uff09\u3092\u5909\u66f4\u3057\u3066\u3044\u307e\u3059\u3002\u672c\u6765\u3001\u30a8\u30af\u30bb\u30ebVBA\u5074\u304b\u3089 \u201cSendMessage\u201d \u3067\u30c1\u30a7\u30c3\u30af\u72b6\u614b\u3092\u53d6\u5f97\u3067\u304d\u308b\u69d8\u306a\u306e\u3067\u3059\u304c\u3001\u3046\u307e\u304f\u3044\u304b\u305a\u3001\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\uff08\u30c6\u30ad\u30b9\u30c8\uff09\u3092\u53d6\u5f97\u3059\u308b\u3053\u3068\u3067\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002\u305f\u3060\u3001\u7406\u7531\u306f\u5224\u308a\u307e\u305b\u3093\u304c\u3001\u30d5\u30ea\u30fc\u306e\u30a2\u30d7\u30ea\u3067\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u72b6\u614b\u3092\u53d6\u5f97\u51fa\u6765\u308b\u3082\u306e\u304c\u3042\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002<br>\u3000\u884c\u756a58\uff5e61\uff0c63\uff5e66\uff0c68\uff5e71 \u306f\u3001\u30dc\u30bf\u30f3\u30af\u30ea\u30c3\u30af\u6642\u306b\u30e1\u30c3\u30bb\u30fc\u30b8\u30dc\u30c3\u30af\u30b9\u3092\u8868\u793a\u3059\u308b\u3082\u306e\u3067\u3059\u3002\u30a8\u30af\u30bb\u30ebVBA\u5074\u304b\u3089\u3001\u30dc\u30bf\u30f3\u30af\u30ea\u30c3\u30af\u76f8\u5f53\u306e\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u9001\u3063\u3066\u3001\u5b9f\u884c\u53ef\u80fd\u3067\u3059\u3002<br>\u3000<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-csharp\" data-file=\"VBA_Ope_TEST.sln\" data-lang=\"C#\"><code>using System;\nusing System.Collections.Generic;\nusing System.ComponentModel;\nusing System.Data;\nusing System.Drawing;\nusing System.Linq;\nusing System.Text;\nusing System.Threading.Tasks;\nusing System.Windows.Forms;\n\nnamespace VBA_Ope_TEST\n{\n    public partial class Form1 : Form\n    {\n        public Form1()\n        {\n            InitializeComponent();\n\n            this.checkBox1.Checked = false;\n            this.checkBox1.Text = &quot;OFF&quot;;\n            this.checkBox2.Checked = false;\n            this.checkBox2.Text = &quot;OFF&quot;;\n\n            this.button3.BringToFront();\n            this.button2.BringToFront();\n            this.button1.BringToFront();\n\n            this.checkBox2.BringToFront();\n            this.checkBox1.BringToFront();\n           \n            this.textBox2.BringToFront();\n            this.textBox1.BringToFront();\n        }\n\n        private void checkBox1_CheckedChanged(object sender, EventArgs e)\n        {\n            if (this.checkBox1.Checked)\n            {\n                this.checkBox1.Text = &quot;ON&quot;;\n            }\n            else {\n                this.checkBox1.Text = &quot;OFF&quot;;\n            }\n        }\n\n        private void checkBox2_CheckedChanged(object sender, EventArgs e)\n        {\n            if (this.checkBox2.Checked)\n            {\n                this.checkBox2.Text = &quot;ON&quot;;\n            }\n            else\n            {\n                this.checkBox2.Text = &quot;OFF&quot;;\n            }\n        }\n\n        private void button1_Click(object sender, EventArgs e)\n        {\n            MessageBox.Show(&quot;\u30dc\u30bf\u30f3 \uff11 \u304c\u30af\u30ea\u30c3\u30af\u3055\u308c\u307e\u3057\u305f\u3002&quot;,&quot;button1_click&quot;,MessageBoxButtons.OK,MessageBoxIcon.Information);\n        }\n\n        private void button2_Click(object sender, EventArgs e)\n        {\n            MessageBox.Show(&quot;\u30dc\u30bf\u30f3 \uff12 \u304c\u30af\u30ea\u30c3\u30af\u3055\u308c\u307e\u3057\u305f\u3002&quot;, &quot;button2_click&quot;, MessageBoxButtons.OK, MessageBoxIcon.Information);\n        }\n\n        private void button3_Click(object sender, EventArgs e)\n        {\n            MessageBox.Show(&quot;\u30dc\u30bf\u30f3 \uff13 \u304c\u30af\u30ea\u30c3\u30af\u3055\u308c\u307e\u3057\u305f\u3002&quot;, &quot;button3_click&quot;, MessageBoxButtons.OK, MessageBoxIcon.Information);\n        }\n\n    }\n}<\/code><\/pre><\/div>\n\n\n\n<h2>(2) \u30a8\u30af\u30bb\u30ebVBA<\/h2>\n\n\n\n<p>\u3000\u30b7\u30fc\u30c8\u306b\u8cbc\u308a\u4ed8\u3051\u3089\u308c\u305f\u30dc\u30bf\u30f3\u306e\u30af\u30ea\u30c3\u30af\u30a4\u30d9\u30f3\u30c8\u3067\u5404\u51e6\u7406\u95a2\u6570\u3092\u547c\u3073\u51fa\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>Option Explicit\n\n\u2019\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u30fb\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\u306e\u5185\u5bb9\u78ba\u8a8d\u30fb\u5909\u66f4\nPrivate Sub CommandButton1_Click()    \n    Call TEST_GetWindowCaption    \nEnd Sub\n\n\u2019\u30dc\u30bf\u30f3\uff11\u30af\u30ea\u30c3\u30af\nPrivate Sub CommandButton2_Click()\n    Call TEST_ClikFormButton(0)\nEnd Sub\n\n\u2019\u30dc\u30bf\u30f3\uff12\u30af\u30ea\u30c3\u30af\nPrivate Sub CommandButton3_Click()\n    Call TEST_ClikFormButton(1)\nEnd Sub\n\n\u2019\u30dc\u30bf\u30f3\uff13\u30af\u30ea\u30c3\u30af\nPrivate Sub CommandButton4_Click()\n    Call TEST_ClikFormButton(2)\nEnd Sub<\/code><\/pre><\/div>\n\n\n\n<p>\u3000\u30b7\u30fc\u30c8\u306e\u30dc\u30bf\u30f3\u30af\u30ea\u30c3\u30af\u30a4\u30d9\u30f3\u30c8\u767a\u751f\u6642\u306b\u547c\u3073\u51fa\u3059\u95a2\u6570\u3067\u3059\u3002\u3000\u3000<\/p>\n\n\n\n<p>\u3010  Sub TEST_ClikFormButton(btn)  \u3011\u884c\u756a24\uff5e41<br>\u3000\u884c\u756a31\u3067\u306f\u30c8\u30c3\u30d7\u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u30cf\u30f3\u30c9\u30eb\u3092\u53d6\u5f97\u3057\u3001\u884c\u756a34\uff5e36\u3067\u4e0b\u4f4d\u5c64\u306e button1 \uff5e 3 \u3092\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\u3092\u6307\u5b9a\u3057\u3001\u305d\u308c\u305e\u308c\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u3092\u53d6\u5f97\u3057\u3066\u3044\u307e\u3059\u3002\u884c\u756a38\u3067 \u5bfe\u8c61button \u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u3092\u6307\u5b9a\u3057\u3001\u30af\u30ea\u30c3\u30af\u51e6\u7406\u306b\u76f8\u5f53\u3059\u308b\u30e1\u30c3\u30bb\u30fc\u30b8\u3092\u9001\u4fe1\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<p>\u3010 Sub TEST_GetWindowCaption() \u3011\u884c\u756a45\uff5e126<br>\u3000\u884c\u756a58\u3067\u30c8\u30c3\u30d7\u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u30cf\u30f3\u30c9\u30eb\u3092\u53d6\u5f97\u3057\u3066\u3044\u307e\u3059\u3002\u884c\u756a63\uff5e122\u306e\u30eb\u30fc\u30d7\u51e6\u7406\u306e\u4e2d\u306e\u884c\u756a65 \u3082\u3057\u304f\u306f \u884c\u756a67 \u306b\u3088\u3063\u3066\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u79fb\u52d5\u3001\u30cf\u30f3\u30c9\u30eb\u3092\u53d6\u5f97\u3057\u3066\u3044\u307e\u3059\u3002\u884c\u756a73\uff5e76 \u3067\u306f\u53d6\u5f97\u3057\u305f\u30a6\u30a3\u30f3\u30c9\u30a6\u30cf\u30f3\u30c9\u30eb\u3092\u6307\u5b9a\u3057\u30a6\u30a3\u30f3\u30c9\u30a6\u540d\uff08\u30c6\u30ad\u30b9\u30c8\u5185\u5bb9\u7b49\uff09\u3092\u53d6\u5f97\u3057\u3066\u3044\u307e\u3059\u3002<br>\u3000\u540c\u4e00\u30a2\u30d7\u30ea\u5185\u306e\u30a6\u30a3\u30f3\u30c9\u30a6\u69cb\u6210\u306f\u6c7a\u307e\u3063\u3066\u3044\u308b\u306e\u3067\u3001Spy++ \u7b49\u3067\u4e88\u3081\u78ba\u8a8d\u3057\u305f\u901a\u308a\u3001\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\uff11\uff08cnt=0\uff09\u3001\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\uff12\uff08cnt=1\uff09\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\uff11\uff08cnt=2\uff09\u3001\u30c1\u30a7\u30c3\u30af\u30dc\u30c3\u30af\u30b9\uff12\uff08cnt=3\uff09\u306e\u9806\u306b\u51e6\u7406\u307e\u3059\u3002\u884c\u756a78\uff5e112 \u3067\u306f\u3001\u5404\u30a6\u30a3\u30f3\u30c9\u30a6\uff08cnt \u56de\u6570\uff09\u306b\u5bfe\u5fdc\u3059\u308b\u51e6\u7406\u3092\u305d\u308c\u305e\u308c\u5b9f\u65bd\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>Option Explicit\n\nPrivate Declare Function FindWindow Lib &quot;user32.dll&quot; Alias &quot;FindWindowA&quot; (ByVal lpClassName As String, ByVal lpWindowName As String) As Long\nPrivate Declare Function FindWindowEx Lib &quot;user32.dll&quot; Alias &quot;FindWindowExA&quot; (ByVal hwndParent As Long, ByVal hwndChildAfter As Long, ByVal lpszClass As String, ByVal lpszWindow As String) As Long\nPrivate Declare Function GetWindow Lib &quot;user32.dll&quot; (ByVal hwnd As Long, ByVal wCmd As Long) As Long\nPrivate Declare Function SendMessage Lib &quot;user32.dll&quot; Alias &quot;SendMessageA&quot; (ByVal hwnd As Long, ByVal msg As Long, ByVal wParam As Long, ByVal lParam As Long) As Long\nPrivate Declare Function SendMessageStr Lib &quot;user32.dll&quot; Alias &quot;SendMessageA&quot; (ByVal hwnd As Long, ByVal wMsg As Long, ByVal wParam As Long, ByVal lParam As String) As Long\nPrivate Declare Sub SetForegroundWindow Lib &quot;user32.dll&quot; (ByVal ms As Long)\n\nConst BM_CLICK = &HF5                   &#39;\u30dc\u30bf\u30f3\u30af\u30ea\u30c3\u30af\nConst WM_SETTEXT = &HC                  &#39;\u30a6\u30a3\u30f3\u30c9\u30a6(\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb)\u306e\u30c6\u30ad\u30b9\u30c8\u3092\u5909\u66f4\nConst WM_GETTEXT = &HD                  &#39;\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u306e\u30ad\u30e3\u30d7\u30b7\u30e7\u30f3\u30fb\u30c6\u30ad\u30b9\u30c8\u3092\u30d0\u30c3\u30d5\u30a1\u306b\u30b3\u30d4\u30fc\nConst WM_GETTEXTLENGTH = &HE            &#39;WM_GETTEXT\u306e\u524d\u306b\u6587\u5b57\u6570\u3092\u8abf\u3079\u308b\n\nConst GW_HWNDFIRST = 0                  &#39;\u6700\u524d\u9762\u30a6\u30a3\u30f3\u30c9\u30a6\u691c\u7d22\nConst GW_HWNDLAST = 1                   &#39;\u6700\u80cc\u9762\u30a6\u30a3\u30f3\u30c9\u30a6\u691c\u7d22\nConst GW_HWNDNEXT = 2                   &#39;\u57fa\u6e96\u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u6b21\u30a6\u30a3\u30f3\u30c9\u30a6\u691c\u7d22\nConst GW_HWNDPREV = 3                   &#39;\u57fa\u6e96\u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u524d\u30a6\u30a3\u30f3\u30c9\u30a6\u691c\u7d22\nConst GW_OWNER = 4                      &#39;\u57fa\u6e96\u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u30aa\u30fc\u30ca\u30fc\u30a6\u30a3\u30f3\u30c9\u30a6\u691c\u7d22\nConst GW_CHILD = 5                      &#39;\u57fa\u6e96\u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u5b50\u30a6\u30a3\u30f3\u30c9\u30a6\u306e\u30c8\u30c3\u30d7\u30ec\u30d9\u30eb\u30a6\u30a3\u30f3\u30c9\u30a6\u691c\u7d22\n\n&#39;\u30b7\u30fc\u30c8\u4e0a\u306e\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u305f\u6642\u306b\u547c\u3073\u51fa\u3059\u95a2\u6570\n&#39;\u30dc\u30bf\u30f3\u756a\u53f7\u3092\u6307\u5b9a\u3057\u3001\u5bfe\u8c61\u30a6\u30a3\u30f3\u30c9\u30a6\u691c\u7d22\u30fb\u30dc\u30bf\u30f3\u30af\u30ea\u30c3\u30af\u30e1\u30c3\u30bb\u30fc\u30b8\u9001\u4fe1\nSub TEST_ClikFormButton(btn)    \n    Dim hParent As Long\n    Dim h_wnd(2) As Long\n    Dim rtn\n    Dim sht\n    \n    sht = ActiveSheet.Name\n    hParent = FindWindow(vbNullString, &quot;VBA_TEST&quot;)    \n    SetForegroundWindow (hParent)\n    \n    h_wnd(0) = FindWindowEx(hParent, 0, vbNullString, &quot;button1&quot;)\n    h_wnd(1) = FindWindowEx(hParent, 0, vbNullString, &quot;button2&quot;)\n    h_wnd(2) = FindWindowEx(hParent, 0, vbNullString, &quot;button3&quot;)\n\n    rtn = SendMessage(h_wnd(btn), BM_CLICK, 0, 0)    \n    Worksheets(sht).Cells(1, 1).Select\n   \nEnd Sub\n\n&#39;C#\u30d5\u30a9\u30fc\u30e0\u30a2\u30d7\u30ea\u306e\u30c8\u30c3\u30d7\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u691c\u7d22\u5f8c\u3001\n\u2019\u5bfe\u8c61\u30a6\u30a3\u30f3\u30c9\u30a6\u3092\u691c\u7d22\u3001\u30c7\u30fc\u30bf\u5185\u5bb9\u78ba\u8a8d\u30fb\u5909\u66f4\u5b9f\u65bd\nSub TEST_GetWindowCaption()\n    \n    Dim sht\n    Dim hParent As Long\n    Dim hwnd(7) As Long\n    Dim hwnd_hex(7)\n    Dim cnt\n    Dim rtn\n    Dim strText As String\n    Dim msg\n\n    sht = ActiveSheet.Name\n    \n    hParent = FindWindow(vbNullString, &quot;VBA_TEST&quot;)\n    SetForegroundWindow (hParent)\n    \n    &#39;\u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u5185\u5bb9\u3092\u78ba\u8a8d\u3057\u3001\u7570\u306a\u308b\u6587\u5b57\u3092\u8a2d\u5b9a\n    cnt = 0\n    Do\n        If cnt = 0 Then\n            hwnd(cnt) = GetWindow(hParent, GW_CHILD)\n        Else\n            hwnd(cnt) = GetWindow(hwnd(cnt - 1), GW_HWNDNEXT)\n        End If\n        \n        hwnd_hex(cnt) = Hex(hwnd(cnt))\n    \n        msg = &quot;&quot;\n        strText = Space(500)\n        rtn = SendMessageStr(hwnd(cnt), WM_GETTEXT, Len(strText), strText)\n        strText = Trim(strText)\n        If strText &lt;&gt; &quot;&quot; Then strText = Left(strText, Len(strText) - 1)\n        \n        If cnt = 0 Then\n            If strText = &quot;Open&quot; Then\n                msg = &quot;Closed&quot;\n            Else\n                msg = &quot;Open&quot;\n            End If\n            \n            rtn = SendMessageStr(hwnd(cnt), WM_SETTEXT, 0, msg)\n            \n        ElseIf cnt = 1 Then\n            If strText = &quot;\u6e96\u5099\u4e2d&quot; Then\n                msg = &quot;\u55b6\u696d\u4e2d&quot;\n            Else\n                msg = &quot;\u6e96\u5099\u4e2d&quot;\n            End If\n            \n            rtn = SendMessageStr(hwnd(cnt), WM_SETTEXT, 0, msg)\n            \n        ElseIf cnt = 2 Then\n            msg = strText\n            \n        ElseIf cnt = 3 Then\n            rtn = SendMessage(hwnd(cnt), BM_CLICK, 0, 0)\n        \n            strText = Space(500)\n            rtn = SendMessageStr(hwnd(cnt), WM_GETTEXT, Len(strText), strText)\n            strText = Trim(strText)\n            If strText &lt;&gt; &quot;&quot; Then strText = Left(strText, Len(strText) - 1)\n        \n            msg = strText\n            \n        Else\n            Exit Do\n            \n        End If\n        \n        If msg &lt;&gt; &quot;&quot; Then\n            Worksheets(sht).Cells(5 + cnt, 4).Value = msg\n        End If\n        \n        If hwnd(cnt) = 0 Then Exit Do\n        \n        cnt = cnt + 1\n        DoEvents\n    Loop\n\n    Worksheets(sht).Cells(1, 1).Select\n    \nEnd Sub<\/code><\/pre><\/div>\n\n\n\n<p>\u3000\u3000<\/p>\n\n\n\n<h2>\u307e\u3068\u3081<\/h2>\n\n\n\n<p>\u3000\u304b\u306a\u308a\u524d\u306b\u540c\u3058\u69d8\u306a\u3053\u3068\u3092\u3057\u307e\u3057\u305f\u304c\u3059\u3063\u304b\u308a\u5fd8\u308c\u3066\u3044\u307e\u3059\u3002\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u4eca\u56de\u306f\u8003\u3048\u65b9\u3092\u6b8b\u3057\u3066\u304a\u304f\u3053\u3068\u306b\u3057\u307e\u3057\u305f\u3002<br><br><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981 \u3000\u30a8\u30af\u30bb\u30ebVBA\u304b\u3089\u3001Visual Studio \u30d5\u30a9\u30fc\u30e0\u30a2\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u64cd\u4f5c\u3059\u308b\u65b9\u6cd5\u306b\u3064\u3044\u3066\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002 \u3000\u6b21\u306e\u52d5\u753b\u3067\u306f\u3001\u30a8\u30af\u30bb\u30ebVBA\u304b\u3089\u3001C#\u30d5\u30a9\u30fc\u30e0\u306e\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3059\u308b\u51e6\u7406 \u3068 \u30c6\u30ad\u30b9\u30c8\u30dc\u30c3\u30af\u30b9\u30fb\u30c1\u30a7 &hellip; <a href=\"https:\/\/kats-eye.net\/info\/2021\/06\/16\/vba-sendmessage\/\" class=\"more-link\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"screen-reader-text\">\u30a8\u30af\u30bb\u30eb VBA\u3067 VS\u30d5\u30a9\u30fc\u30e0\u30a2\u30d7\u30ea\u64cd\u4f5c<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":6057,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[98],"tags":[80,96,95],"_links":{"self":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/6042"}],"collection":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/comments?post=6042"}],"version-history":[{"count":44,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/6042\/revisions"}],"predecessor-version":[{"id":6091,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/posts\/6042\/revisions\/6091"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/media\/6057"}],"wp:attachment":[{"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/media?parent=6042"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/categories?post=6042"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kats-eye.net\/info\/wp-json\/wp\/v2\/tags?post=6042"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}