memo text変換
Sub output()'変数宣言Dim maxRow, maxCol As LongDim name, data, path As String'最終行・最終列取得maxRow = Cells(1, 1).End(xlDown).RowmaxCol = Cells(1, 1).End(xlToRight).Column'1行ずつ書き出しFor i = 1 To maxRow'名前(A列)name = Cells(i, 1).Value'データ内容(B~列)data = ""