{"id":13195,"date":"2020-09-22T16:29:46","date_gmt":"2020-09-22T07:29:46","guid":{"rendered":"https:\/\/www.ka-net.org\/blog\/?p=13195"},"modified":"2021-09-15T10:39:45","modified_gmt":"2021-09-15T01:39:45","slug":"office-vbaado%e3%81%a7sharepoint%e3%83%aa%e3%82%b9%e3%83%88%e3%81%ab%e6%8e%a5%e7%b6%9a%e3%81%99%e3%82%8b%e6%96%b9%e6%b3%95","status":"publish","type":"post","link":"https:\/\/www.ka-net.org\/blog\/?p=13195","title":{"rendered":"[Office VBA]ADO\u3067SharePoint\u30ea\u30b9\u30c8\u306b\u63a5\u7d9a\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"<p>\u5148\u65e5Twitter\u3067 <a href=\"https:\/\/twitter.com\/blacklist_ryu\" title=\"\u308a\u3085\u3046\u308a\u3085\u3046\u3055\u3093 (@blacklist_ryu) \/ Twitter\" target=\"_blank\" rel=\"noopener noreferrer\">@blacklist_ryu<\/a> \u3055\u3093\u304c\u4e0b\u8a18\u30c4\u30a4\u30fc\u30c8\u3092\u3055\u308c\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n<blockquote class=\"twitter-tweet\">\n<p lang=\"ja\" dir=\"ltr\">\u3053\u3053\u3067\u82e6\u6226\u4e2d\u30fb\u30fb\u30fb\u8aac\u660e\u304c\u3056\u3063\u304f\u308a\u3060\u30fb\u30fb <a href=\"https:\/\/t.co\/7J10zpHK2H\">https:\/\/t.co\/7J10zpHK2H<\/a> <a href=\"https:\/\/t.co\/TFyrVnTAeA\">pic.twitter.com\/TFyrVnTAeA<\/a><\/p>\n<p>&mdash; \u308a\u3085\u3046\u308a\u3085\u3046 (@blacklist_ryu) <a href=\"https:\/\/twitter.com\/blacklist_ryu\/status\/1306799190643634176?ref_src=twsrc%5Etfw\">September 18, 2020<\/a><\/p><\/blockquote>\n<p> <script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script> <\/p>\n<p>ADO\u3067SharePoint\u30ea\u30b9\u30c8\u306b\u63a5\u7d9a\u3059\u308b\u3068\u3053\u308d\u3067\u82e6\u6226\u3055\u308c\u3066\u3044\u308b\u3088\u3046\u3067\u3001\u79c1\u3082\u6c17\u306b\u306a\u3063\u305f\u306e\u3067\u78ba\u8a8d\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<h4 class=\"style4a\">\u53c2\u8003\u30b5\u30a4\u30c8<\/h4>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/econoshift.com\/ja\/excel-sharepoint-method-basics\/\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=econoshift.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">econoshift.com<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/pz-linkcard\/cache\/b812310e09e2fa56a9376a692b2e207c590f9fee8622bac91e12f21f288efc72.jpeg\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">\u30a8\u30af\u30bb\u30eb\u3068SharePoint\u306eADO\u9023\u643a\u306e\u4ed5\u65b9\u3001\u6982\u8981\uff08ADO\u3068SQL\u306e\u8d85\u7c21\u5358\u306a\u8aac\u660e\u3082\uff09<\/div><div class=\"lkc-url\" title=\"https:\/\/econoshift.com\/ja\/excel-sharepoint-method-basics\/\">https:\/\/econoshift.com\/ja\/excel-sharepoint-method-basics\/<\/div><div class=\"lkc-excerpt\">\u3053\u306e\u8a18\u4e8b\u3067\u306f\u7d4c\u55b6\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u3084\u696d\u52d9\u30b7\u30b9\u30c6\u30e0\u3092\u4f5c\u308b\u305f\u3081\u306e\u30a8\u30af\u30bb\u30eb\u3068SharePoint\u306e\u9023\u643a\u306e\u4ed5\u7d44\u307f\u3092\u5206\u304b\u308a\u6613\u304f\u8aac\u660e\u3057\u307e\u3059\u3002\u305d\u306e\u63a5\u7d9a\u306e\u4e2d\u5fc3\u3068\u306a\u308b\u63a5\u7d9a\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u306eADO\u3068\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u5c02\u7528\u8a00\u8a9e\u306eSQL\u306b\u3064\u3044\u3066\u56f3\u89e3\u3057\u3066\u3044\u307e\u3059\u3002<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"http:\/\/nyoro2.net\/wp\/?p=398\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=nyoro2.net\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">nyoro2.net<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"https:\/\/s.wordpress.com\/mshots\/v1\/http%3A%2F%2Fnyoro2.net%2Fwp%2F%3Fp%3D398?w=100\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">SharePoint \u306e\u30c7\u30fc\u30bf\u3092 ADO \u306a\u3069\u3067\u8aad\u3080 | NYORO PRESS<\/div><div class=\"lkc-url\" title=\"http:\/\/nyoro2.net\/wp\/?p=398\">http:\/\/nyoro2.net\/wp\/?p=398<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<p>\u4e0a\u8a18\u30b5\u30a4\u30c8\u306b\u3088\u308b\u3068\u3001SharePoint\u30b5\u30a4\u30c8\u306eURL\u3068\u30ea\u30b9\u30c8\u306eID\u3055\u3048\u5206\u304b\u308c\u3070\u63a5\u7d9a\u3067\u304d\u308b\u3088\u3046\u306a\u306e\u3067\u3001\u307e\u305a\u306fID(GUID)\u3092\u53d6\u5f97\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n<h4 class=\"style4a\">\u30da\u30fc\u30b8\u306e\u30bd\u30fc\u30b9\u304b\u3089SharePoint\u30ea\u30b9\u30c8ID\u3092\u53d6\u5f97<\/h4>\n<p>\u63a5\u7d9a\u3057\u305f\u3044\u30ea\u30b9\u30c8\u3092\u30d6\u30e9\u30a6\u30b6\u30fc\u3067\u958b\u304d\u3001\u30bd\u30fc\u30b9\u3092\u8868\u793a\u3057\u305f\u3068\u3053\u308d\u3001\u300c<span style=\"color: #ff0000; font-weight: bold;\">listId<\/span>\u300d\u3068\u3057\u3066\u3001\u305d\u308c\u3089\u3057\u3044\u5024\u304c\u8f09\u3063\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_01.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_01.jpg\" alt=\"\" width=\"844\" height=\"590\" class=\"alignnone size-full wp-image-13196\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_01.jpg 844w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_01-300x210.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_01-768x537.jpg 768w\" sizes=\"auto, (max-width: 844px) 100vw, 844px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_02.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_02.jpg\" alt=\"\" width=\"832\" height=\"192\" class=\"alignnone size-full wp-image-13197\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_02.jpg 832w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_02-300x69.jpg 300w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_02-768x177.jpg 768w\" sizes=\"auto, (max-width: 832px) 100vw, 832px\" \/><\/a><\/p>\n<p>\u305f\u3060\u3001\u3053\u306e\u65b9\u6cd5\u3067\u306f\u30b5\u30a4\u30c8\u306e\u4ed5\u69d8\u304c\u5909\u308f\u308b\u3068ID\u304c\u53d6\u5f97\u3067\u304d\u306a\u304f\u306a\u308b\u53ef\u80fd\u6027\u3082\u3042\u308b\u306e\u3067\u3001\u5225\u306e\u65b9\u6cd5\u3082\u8a66\u3057\u3066\u307f\u307e\u3059\u3002<\/p>\n<h4 class=\"style4a\">Get-PnPList\u306b\u3088\u308bSharePoint\u30ea\u30b9\u30c8ID\u306e\u53d6\u5f97<\/h4>\n<p>\u300c<a href=\"https:\/\/www.sharepointdiary.com\/2018\/08\/get-list-id-sharepoint-online-powershell.html\" title=\"SharePoint Online: PowerShell to Get List ID (GUID) - SharePoint Diary\" target=\"_blank\" rel=\"noopener noreferrer\">SharePoint Online: PowerShell to Get List ID (GUID)<\/a>\u300d\u306b\u3088\u308b\u3068\u3001PnP PowerShell\u30e9\u30a4\u30d6\u30e9\u30ea\u306e<a href=\"https:\/\/docs.microsoft.com\/ja-jp\/powershell\/module\/sharepoint-pnp\/get-pnplist?WT.mc_id=M365-MVP-4029057\" title=\"Get-PnPList\" target=\"_blank\" rel=\"noopener noreferrer\">Get-PnPList<\/a>\u3067\u7c21\u5358\u306b\u53d6\u5f97\u3067\u304d\u305d\u3046\u3067\u3059\u3002<\/p>\n<h5 class=\"style5a\">PnP PowerShell\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h5>\n<p>PnP PowerShell\u3092\u307e\u3060\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u3001PowerShell(\u7ba1\u7406\u8005\u6a29\u9650)\u3067\u4e0b\u8a18\u30b3\u30de\u30f3\u30c9\u3092\u5b9f\u884c\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: powershell; title: ; notranslate\" title=\"\">Install-Module SharePointPnPPowerShellOnline<\/pre>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/docs.microsoft.com\/ja-jp\/powershell\/sharepoint\/sharepoint-pnp\/sharepoint-pnp-cmdlets?WT.mc_id=M365-MVP-4029057\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=docs.microsoft.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">docs.microsoft.com<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"https:\/\/s.wordpress.com\/mshots\/v1\/https%3A%2F%2Fdocs.microsoft.com%2Fja-jp%2Fpowershell%2Fsharepoint%2Fsharepoint-pnp%2Fsharepoint-pnp-cmdlets%3FWT.mc_id%3DM365-MVP-4029057?w=100\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">PnP PowerShell \u306e\u6982\u8981<\/div><div class=\"lkc-url\" title=\"https:\/\/docs.microsoft.com\/ja-jp\/powershell\/sharepoint\/sharepoint-pnp\/sharepoint-pnp-cmdlets?WT.mc_id=M365-MVP-4029057\">https:\/\/docs.microsoft.com\/ja-jp\/powershell\/sharepoint\/sharepoint-pnp\/sharepoint-pnp-cmdlets?WT.mc_id=M365-MVP-4029057<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<h4 class=\"style4a\">Get-PnPList\u306e\u5b9f\u884c<\/h4>\n<p>PnP PowerShell\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u3066\u3044\u308c\u3070\u3001\u4e0a\u8a18<a href=\"https:\/\/www.sharepointdiary.com\/2018\/08\/get-list-id-sharepoint-online-powershell.html\" title=\"SharePoint Online: PowerShell to Get List ID (GUID) - SharePoint Diary\" target=\"_blank\" rel=\"noopener noreferrer\">\u53c2\u8003\u30b5\u30a4\u30c8<\/a>\u306b\u3042\u308b\u901a\u308a\u3001Get-PnPList\u3067ID\u542b\u3081\u3066\u30b5\u30a4\u30c8\u306e\u60c5\u5831\u3092\u5217\u6319\u3067\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"brush: powershell; title: ; notranslate\" title=\"\">$url = &quot;https:\/\/****.sharepoint.com\/&quot;\r\n$usr = &quot;(user)@****.onmicrosoft.com&quot;\r\n$cred = Get-Credential -UserName $usr -Message &quot;Type the password.&quot;\r\nConnect-PnPOnline -Url $url -Credentials $cred\r\nGet-PnPList | Select-Object Title, Id<\/pre>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_03.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_03.jpg\" alt=\"\" width=\"411\" height=\"109\" class=\"alignnone size-full wp-image-13198\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_03.jpg 411w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_03-300x80.jpg 300w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><\/a><\/p>\n<h4 class=\"style4a\">ADO\u3067SharePoint\u30ea\u30b9\u30c8\u306b\u63a5\u7d9a\u3059\u308b\u65b9\u6cd5<\/h4>\n<p>\u30ea\u30b9\u30c8\u306eID\u3055\u3048\u5206\u304b\u308c\u3070\u3001\u3042\u3068\u306fADO\u3067\u63a5\u7d9a\u3059\u308b\u3060\u3051\u3067\u3059\u306d\uff01<br \/>\n\u63a5\u7d9a\u6587\u5b57\u5217\u306f\u4e0b\u8a18\u30b5\u30a4\u30c8\u306b\u5206\u304b\u308a\u3084\u3059\u304f\u307e\u3068\u3081\u3066\u3042\u308a\u307e\u3057\u305f\u3002<\/p>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/www.connectionstrings.com\/ace-oledb-12-0\/#sharepoint\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=www.connectionstrings.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">www.connectionstrings.com<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"https:\/\/s.wordpress.com\/mshots\/v1\/https%3A%2F%2Fwww.connectionstrings.com%2Face-oledb-12-0%2F%23sharepoint?w=100\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">Microsoft ACE OLEDB 12.0 Connection Strings - ConnectionStrings.com<\/div><div class=\"lkc-url\" title=\"https:\/\/www.connectionstrings.com\/ace-oledb-12-0\/#sharepoint\">https:\/\/www.connectionstrings.com\/ace-oledb-12-0\/#sharepoint<\/div><div class=\"lkc-excerpt\">Connection Strings using Microsoft.ACE.OLEDB.12.0 for connections to Excel, Access, DBF \/ FoxPro, SharePoint, Excel 97, Excel 2000, Excel 2002, Excel 2003.<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<pre class=\"brush: vb; title: ; notranslate\" title=\"\">Public Sub Sample()\r\n  Dim cn As Object 'ADODB.Connection\r\n  Dim rs As Object 'ADODB.Recordset\r\n  Const SharePointUrl As String = &quot;https:\/\/****.sharepoint.com\/&quot;\r\n  Const ListId As String = &quot;{********-****-****-****-************}&quot;\r\n  \r\n  Set cn = CreateObject(&quot;ADODB.Connection&quot;)\r\n  cn.Open &quot;Provider=Microsoft.ACE.OLEDB.16.0;WSS;IMEX=2;RetrieveIds=Yes;DATABASE=&quot; &amp; SharePointUrl &amp; &quot;;LIST=&quot; &amp; ListId &amp; &quot;;&quot; '\u30d7\u30ed\u30d0\u30a4\u30c0\u30fc\u306f\u9069\u5b9c\u5909\u66f4\r\n  Set rs = CreateObject(&quot;ADODB.Recordset&quot;)\r\n  With rs\r\n    .Open &quot;SELECT * FROM list&quot;, cn\r\n    .MoveFirst\r\n    Do Until .EOF\r\n      Debug.Print .Fields.Item(&quot;Name&quot;).Value\r\n      .MoveNext\r\n    Loop\r\n    .Close\r\n  End With\r\n  cn.Close\r\nEnd Sub<\/pre>\n<p>\u4e0a\u8a18\u30b3\u30fc\u30c9\u5b9f\u884c\u6642\u3001365\u30a2\u30ab\u30a6\u30f3\u30c8\u3067\u30b5\u30a4\u30f3\u30a4\u30f3\u3057\u3066\u3044\u306a\u3044\u5834\u5408\u306f\u4e0b\u56f3\u306e\u3088\u3046\u306a\u30ed\u30b0\u30a4\u30f3\u753b\u9762\u304c\u8868\u793a\u3055\u308c\u308b\u306e\u3067\u3001\u5fc5\u8981\u4e8b\u9805\u3092\u5165\u529b\u3057\u3066\u30b5\u30a4\u30f3\u30a4\u30f3\u3057\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_04.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_04.jpg\" alt=\"\" width=\"701\" height=\"670\" class=\"alignnone size-full wp-image-13199\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_04.jpg 701w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_04-300x287.jpg 300w\" sizes=\"auto, (max-width: 701px) 100vw, 701px\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_05.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_05.jpg\" alt=\"\" width=\"527\" height=\"629\" class=\"alignnone size-full wp-image-13200\" srcset=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_05.jpg 527w, https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_05-251x300.jpg 251w\" sizes=\"auto, (max-width: 527px) 100vw, 527px\" \/><\/a><\/p>\n<p>\u63a5\u7d9a\u306b\u554f\u984c\u304c\u7121\u3051\u308c\u3070\u3001\u4e0b\u56f3\u306e\u3088\u3046\u306b\u30ea\u30b9\u30c8\u306e\u5185\u5bb9\u304c\u51fa\u529b\u3055\u308c\u307e\u3059\u3002<\/p>\n<p><a href=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_06.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/ADO_SharePointList_06.jpg\" alt=\"\" width=\"244\" height=\"215\" class=\"alignnone size-full wp-image-13201\" \/><\/a><\/p>\n<div id=\"single_banner_area2\" class=\"clearfix one_banner\">\n<div class=\"single_banner single_banner_left\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- \u8a18\u4e8b\u4e2d(\u30c7\u30a3\u30b9\u30d7\u30ec\u30a4\u5e83\u544a\u30e6\u30cb\u30c3\u30c8) -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-7306936664602087\"\r\n     data-ad-slot=\"5429724765\"\r\n     data-ad-format=\"auto\"\r\n     data-full-width-responsive=\"true\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<div class=\"single_banner single_banner_right\">\n<a href=\"\" target=\"_blank\"><img decoding=\"async\" src=\"\" alt=\"\" title=\"\" \/><\/a>\n<\/div>\n<\/div>\n\n<p>SharePoint\u306e\u30ea\u30b9\u30c8\u306b\u95a2\u3057\u3066\u306f\u3001\u30ed\u30fc\u30eb\u30a2\u30a6\u30c8\u304c\u59cb\u307e\u3063\u305f\u3070\u304b\u308a\u306eMicrosoft Lists\u3068\u3001\u3069\u306e\u3088\u3046\u306a\u4f7f\u3044\u5206\u3051\u304c\u3055\u308c\u3066\u3044\u304f\u306e\u304b\u307e\u3060\u4e0d\u900f\u660e\u306a\u90e8\u5206\u304c\u3042\u308a\u307e\u3059\u304c\u3001\u3059\u3050\u306b\u4f7f\u3048\u306a\u304f\u306a\u308b\u3053\u3068\u306f\u7121\u3044\u3060\u308d\u3046\u3068\u601d\u3044\u307e\u3059\u3002<br \/>\n(Microsoft Lists\u306b\u95a2\u3057\u3066\u306f\u4e0b\u8a18 <a href=\"https:\/\/twitter.com\/ai_yamasaki\" title=\"Ai Hirano | Microsoft MVP\u3055\u3093 (@ai_yamasaki) \/ Twitter\" target=\"_blank\" rel=\"noopener noreferrer\">@ai_yamasaki<\/a> \u3055\u3093\u306e\u30d6\u30ed\u30b0\u3067\u8a73\u3057\u304f\u8aac\u660e\u3055\u308c\u3066\u3044\u307e\u3059\u3002)<\/p>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/shanqiai.weblogs.jp\/sharepoint_technical_note\/microsoft-lists\/\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=shanqiai.weblogs.jp\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">SharePoint Technical Notes<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/pz-linkcard\/cache\/3ee7d84543b7ec81291b06410dc8ad26d9ba74c650f10b4aef9875f9bbdb5ff9.jpeg\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">SharePoint Technical Notes<\/div><div class=\"lkc-url\" title=\"https:\/\/shanqiai.weblogs.jp\/sharepoint_technical_note\/microsoft-lists\/\">https:\/\/shanqiai.weblogs.jp\/sharepoint_technical_note\/microsoft-lists\/<\/div><div class=\"lkc-excerpt\">&lt;table&gt;&lt;tr&gt;&lt;td&gt;&lt;a href=&quot;http:\/\/www.office-i-corp.jp\/&quot; target=&quot;_blank&quot;&gt;\u30aa\u30d5\u30a3\u30b9\u30a2\u30a4\u682a\u5f0f\u4f1a\u793e&lt;\/a&gt; \u306e\u5e73\u91ce \u611b\u3000(\u65e7\u59d3:\u5c71\u5d0e)  \u304cMicrosoft SharePoint \u306b\u95a2\u3059\u308b\u6280\u8853\u60c5\u5831\u3092\u63d0\u4f9b\u3057\u307e\u3059\u3002&lt;\/td&gt;&lt;td&gt;&lt;img src=&quot;https:\/\/shanqiai.weblogs.jp\/sharepoint_technical_note\/images\/banner\/office-i-Logo.png&quot; width=&quot;230px&quot;\/&gt;&lt;\/td&gt;&lt;\/tr&gt;&lt;\/table&gt;&lt;hr\/&gt;Microsoft SharePoint \u306e\u904b\u7528\u7ba1\u7406\u3001\u6d3b\u7528\u65b9\u6cd5\u3001\u6280\u8853\u7814\u4fee\u306b\u95a2\u3057\u3066\u306e\u3054\u76f8\u8ac7\u306f...<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<p>\u307e\u305f\u3001ADO\u306b\u3088\u308bSharePoint\u30ea\u30b9\u30c8\u3078\u306e\u63a5\u7d9a\u306b\u95a2\u3057\u3066\u691c\u7d22\u3057\u305f\u3068\u3053\u308d\u3001\u4e0b\u8a18\u30b5\u30a4\u30c8\u3092\u898b\u3064\u3051\u307e\u3057\u305f\u3002<\/p>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/mukkumuku.blogspot.com\/2011\/04\/access2010-sharepoint-ado.html\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=mukkumuku.blogspot.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">mukkumuku.blogspot.com<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"https:\/\/s.wordpress.com\/mshots\/v1\/https%3A%2F%2Fmukkumuku.blogspot.com%2F2011%2F04%2Faccess2010-sharepoint-ado.html?w=100\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">access2010 SharePoint\u30ea\u30b9\u30c8 ADO\u63a5\u7d9a<\/div><div class=\"lkc-url\" title=\"https:\/\/mukkumuku.blogspot.com\/2011\/04\/access2010-sharepoint-ado.html\">https:\/\/mukkumuku.blogspot.com\/2011\/04\/access2010-sharepoint-ado.html<\/div><div class=\"lkc-excerpt\">Microsoft Access\u3092\u8d77\u70b9\u306b\u3057\u3066SharePoint\u3084Office365\u306a\u3069\u8208\u5473\u304c\u3042\u308b\u3082\u306e\u3060\u3051\u306e\u5099\u5fd8\u3002<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<p>\u3053\u308c\u306b\u3088\u308b\u3068\u3001\u63a5\u7d9a\u3059\u308b\u969b\u306f\u30ea\u30b9\u30c8\u306eID\u3067\u306f\u306a\u304f\u3001\u30ea\u30b9\u30c8\u540d\u3067\u3082\u5927\u4e08\u592b\u306a\u3088\u3046\u3067\u3059\u3002<br \/>\n\u308f\u3056\u308f\u3056ID\u3092\u53d6\u5f97\u3057\u305f\u624b\u9593\u306f\u4e00\u4f53\u4f55\u3060\u3063\u305f\u3093\u3060\u30fb\u30fb\u30fb\uff01\uff1f&#x1f605;<\/p>\n<h4 class=\"style4a\">ADO\u306e\u89e3\u8aac\u30b5\u30a4\u30c8<\/h4>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/excel-ubara.com\/excelvba4\/EXCEL273.html\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=excel-ubara.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">\u30a8\u30af\u30bb\u30eb\u306e\u795e\u9ac4<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/pz-linkcard\/cache\/dbd38de3d86d4da65b411c4e47cc6c1645654f7547ae6bdcc0480cc0325fac80.jpeg\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">ADO(ActiveX Data Objects)\u306e\u4f7f\u3044\u65b9\u306e\u8981\u70b9\uff5cVBA\u6280\u8853\u89e3\u8aac<\/div><div class=\"lkc-url\" title=\"https:\/\/excel-ubara.com\/excelvba4\/EXCEL273.html\">https:\/\/excel-ubara.com\/excelvba4\/EXCEL273.html<\/div><div class=\"lkc-excerpt\">ADO\u306fMicrosoft\u304c\u63d0\u4f9b\u3059\u308b\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30a2\u30af\u30bb\u30b9\u306e\u305f\u3081\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u90e8\u54c1\u3067\u3059\u3002OLEDB\u3092ActiveX\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u306e\u5f62\u3067\u4f7f\u3048\u308b\u3088\u3046\u306b\u3057\u305f\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u30a4\u30f3\u30bf\u30fc\u30d5\u30a7\u30fc\u30b9\u306b\u306a\u308a\u307e\u3059\u3002\u3053\u3053\u3067\u306f\u3001ADO\u3092\u4f7f\u7528\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3078\u306e\u63a5\u7d9a\u65b9\u6cd5\u3092\u89e3\u8aac\u3057\u307e\u3059\u3002<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<hr \/>\n<p><span style=\"color: #ff0000; font-weight: bold;\">2021\/9\/15 \u8ffd\u8a18\uff1a<\/span><br \/>\n<a href=\"https:\/\/twitter.com\/KotorinChunChun\" title=\"\u3061\u3085\u3093&#x1f423;VBAer\u3055\u3093 (@KotorinChunChun) \/ Twitter\" target=\"_blank\" rel=\"noopener\">@KotorinChunChun<\/a> \u3055\u3093\u304b\u3089\u4e0b\u8a18\u3054\u5831\u544a\u3092\u3044\u305f\u3060\u304d\u307e\u3057\u305f\u3002<\/p>\n<blockquote class=\"twitter-tweet\">\n<p lang=\"ja\" dir=\"ltr\"><a href=\"https:\/\/twitter.com\/hashtag\/%E5%8A%A9%E3%81%91%E3%81%A6VBA?src=hash&amp;ref_src=twsrc%5Etfw\">#\u52a9\u3051\u3066VBA<\/a> <br \/>VBA\u304b\u3089ADODB\u3067SharePoint\u30ea\u30b9\u30c8\u306b\u63a5\u7d9a\u3057\u3066\u3001\u30ec\u30b3\u30fc\u30c9\u3092\u8ffd\u52a0\u3057\u3088\u3046\u3068\u3059\u308b\u3068\u3001Update\u30e1\u30bd\u30c3\u30c9\u5b9f\u884c\u6642\u306b\u300c\u884c\u30cf\u30f3\u30c9\u30eb\u306f\u7121\u52b9\u3067\u3059\u300d\u304c\u8868\u793a\u3055\u308c\u308b\u3093\u3067\u3059\u304c\u3001\u8ffd\u52a0\u3059\u308b\u3053\u3068\u306f\u51fa\u6765\u306a\u3044\u3093\u3067\u3057\u3087\u3046\u304b\uff1f<\/p>\n<p>\u203b\u8aad\u307f\u8fbc\u307f\u307e\u3067\u306f\u4e0b\u8a18\u3092\u53c2\u8003\u306b\u8a2d\u5b9a\u3057\u3066\u6210\u529f\u3057\u3066\u307e\u3059\u3002<a href=\"https:\/\/t.co\/MsQDuqiaNi\">https:\/\/t.co\/MsQDuqiaNi<\/a><\/p>\n<p>&mdash; \u3061\u3085\u3093&#x1f423;VBAer (@KotorinChunChun) <a href=\"https:\/\/twitter.com\/KotorinChunChun\/status\/1437660242410500104?ref_src=twsrc%5Etfw\">September 14, 2021<\/a><\/p><\/blockquote>\n<p> <script async src=\"https:\/\/platform.twitter.com\/widgets.js\" charset=\"utf-8\"><\/script><\/p>\n<p>Update\u30e1\u30bd\u30c3\u30c9\u3067\u884c\u30cf\u30f3\u30c9\u30eb\u7121\u52b9\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u3068\u306e\u3053\u3068\u3002<br \/>\n\u79c1\u3082\u4ee5\u524d\u540c\u69d8\u306e\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u3053\u3068\u304c\u3042\u308b\u306e\u3067\u3059\u304c\u3001\u305d\u306e\u3068\u304d\u306f\u5165\u529b\u304c\u5fc5\u9808\u306b\u306a\u3063\u3066\u3044\u308b\u5217\u304c\u672a\u5165\u529b\u306b\u306a\u3063\u3066\u3044\u308b\u3053\u3068\u304c\u539f\u56e0\u3067\u3057\u305f\u3002<br \/>\n\u4ed6\u306b\u3082\u540c\u69d8\u306b\u4e8b\u4f8b\u304c\u306a\u3044\u304b\u691c\u7d22\u3057\u305f\u3068\u3053\u308d\u3001\u4e0b\u8a18\u306e\u8cea\u554f\u304c\u30d2\u30c3\u30c8\u3057\u307e\u3057\u305f\u3002<\/p>\n<div class=\"linkcard\"><div class=\"lkc-external-wrap\"><a class=\"lkc-link no_icon\" href=\"https:\/\/stackoverflow.com\/questions\/50255127\/row-handle-is-invalid-error-excel-vba-sharepoint-list-automation\" target=\"_blank\" rel=\"external nofollow noopener\"><div class=\"lkc-card\"><div class=\"lkc-info\"><div class=\"lkc-favicon\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.google.com\/s2\/favicons?domain=stackoverflow.com\" alt=\"\" width=\"16\" height=\"16\" \/><\/div><div class=\"lkc-domain\">Stack Overflow<\/div><\/div><div class=\"lkc-content\"><figure class=\"lkc-thumbnail\"><img decoding=\"async\" class=\"lkc-thumbnail-img\" src=\"\/\/www.ka-net.org\/blog\/wp-content\/uploads\/pz-linkcard\/cache\/93927fc1e64dd3e5b86b87f2a89b3b29bc3a30e0e6b7a2312393a2a6226faaba.jpeg\" width=\"100px\" height=\"108px\" alt=\"\" \/><\/figure><div class=\"lkc-title\">&quot;Row handle is invalid&quot; error, Excel, VBA, SharePoint list automation<\/div><div class=\"lkc-url\" title=\"https:\/\/stackoverflow.com\/questions\/50255127\/row-handle-is-invalid-error-excel-vba-sharepoint-list-automation\">https:\/\/stackoverflow.com\/questions\/50255127\/row-handle-is-invalid-error-excel-vba-sharepoint-list-automation<\/div><div class=\"lkc-excerpt\">I am trying to automate population of a SharePoint list, but getting &quot;Row handle is invalid&quot; error.My code:Sub test() Dim cnt As New ADODB.Connection Dim rst As New ADODB.Recordset Dim SQLstr...<\/div><\/div><div class=\"clear\"><\/div><\/div><\/a><\/div><\/div>\n<blockquote><p>Did you check the SharePoint list mandatory fields? Few columns would automatically be marked as &#8216;Required&#8217; (eg: Title column). Removing such criteria or including such columns in the code by passing a value would help.<\/p><\/blockquote>\n<p><a href=\"https:\/\/stackoverflow.com\/questions\/50255127\/row-handle-is-invalid-error-excel-vba-sharepoint-list-automation\" title=\"&quot;Row handle is invalid&quot; error, Excel, VBA, SharePoint list automation - Stack Overflow\" target=\"_blank\" rel=\"noopener\">https:\/\/stackoverflow.com\/questions\/50255127\/row-handle-is-invalid-error-excel-vba-sharepoint-list-automation<\/a> \u3088\u308a<\/p>\n<p>\u3068\u306e\u56de\u7b54\u304c\u5bc4\u305b\u3089\u308c\u3066\u3044\u305f\u306e\u3067\u3001\u307e\u305a\u306f\u5165\u529b\u5fc5\u9808\u3068\u306a\u3063\u3066\u3044\u308b\u5217\u3092\u78ba\u8a8d\u3059\u308b\u306e\u304c\u826f\u3044\u306e\u304b\u3082\u3057\u308c\u307e\u305b\u3093&#x1f642;<\/p>\n","protected":false},"excerpt":{"rendered":"\u5148\u65e5Twitter\u3067 @blacklist_ryu \u3055\u3093\u304c\u4e0b\u8a18\u30c4\u30a4\u30fc\u30c8\u3092\u3055\u308c\u3066\u3044\u307e\u3057\u305f\u3002 \u3053\u3053\u3067\u82e6\u6226\u4e2d\u30fb\u30fb\u30fb\u8aac\u660e\u304c\u3056\u3063\u304f\u308a\u3060\u30fb\u30fb https:\/\/t.co\/7J10zpHK2H pic.twitter.com\/TFyrV [&hellip;]","protected":false},"author":1,"featured_media":7120,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"[[Office VBA]ADO\u3067SharePoint\u30ea\u30b9\u30c8\u306b\u63a5\u7d9a\u3059\u308b\u65b9\u6cd5]","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4,112],"tags":[],"class_list":["post-13195","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-office","category-office365"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.ka-net.org\/blog\/wp-content\/uploads\/eyecatch-OfficeVBA.png","jetpack_shortlink":"https:\/\/wp.me\/p4UZZr-3qP","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/13195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=13195"}],"version-history":[{"count":4,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/13195\/revisions"}],"predecessor-version":[{"id":14056,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/posts\/13195\/revisions\/14056"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=\/wp\/v2\/media\/7120"}],"wp:attachment":[{"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=13195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=13195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ka-net.org\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=13195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}