ray88’s diary

お仕事で困ったとき用の自分用の覚書

2022-09-04から1日間の記事一覧

サンプルコード

Sub ExcelにSQLをかける() Dim adoCN As Object Dim adoRS As Object Dim strBookPath As String Dim wb As Workbook Dim lastRow As Long Dim arMaster As Variant Dim arKeySet As Variant Dim i As Long Dim str_条件1 As String Dim str_条件2 As String…