思考の漏洩

間違ってたら教えてください

2023-03-01から1ヶ月間の記事一覧

Sub MergeCSVFiles4()

Sub MergeCSVFiles4() 'フォルダのパスを指定 'ユーザーにCSVファイルが格納されたフォルダを選択してもらう MsgBox "データをまとめるCSVファイルが格納されているフォルダを選択してください", vbOKOnly With Application.FileDialog(msoFileDialogFolderP…

Sub MergeCSVFiles4()

https://docs.google.com/document/d/1NXBEfdUE5sEmXlrhfpVuD5gcKlOzTx6a6tAxKBOSzmA/edit?usp=sharing

ああ

https://docs.google.com/document/d/11dL1ofvivI9UwfSSstAYj_to3K3FYPOjJ0XNkp4-71U/edit

Sub MergeCSVToExcel() Dim folderPath As String Dim csvFile As String Dim csvContent As String Dim rowPosition As Long Dim columnPosition As Long Dim currentWorkbook As Workbook Dim targetWorkbook As Workbook Dim targetWorksheet As Workshee…

くりかえし

Sub MacroB()Dim result As Integerresult = MsgBox("Do you want to run macro A?", vbYesNo, "Confirmation")If result = vbNo ThenCall MacroAAElseCall MacroBEnd IfEnd Sub Sub MacroAA()' ここにマクロAの処理を記述するEnd Sub

データを貼り付けるマクロ

Sub ImportDataFromSelectedFile() Dim selectedFile As Variant Dim targetSheet As Worksheet Dim targetRange As Range Dim initialSelection As Range Dim message As String Dim response As Integer ' 元の選択範囲を取得 Set initialSelection = Sele…