PwoerAutomateを利用して、クライアントPCにつぎつぎとフォルダコピーするRPAのシナリオをつくった。。

Excel.LaunchExcel.LaunchAndOpen Path: $”’D:\テスト\ダミーデータ.xlsx”’ Visible: False ReadOnly: True LoadAddInsAndMacros: False Instance=> ExcelInstance
Excel.SetActiveWorksheet.ActivateWorksheetByIndex Instance: ExcelInstance Index: 1
Excel.GetFirstFreeRowOnColumn Instance: ExcelInstance Column: $”’A”’ FirstFreeRowOnColumn=> FirstFreeRowOnColumn
Excel.ReadFromExcel.ReadCells Instance: ExcelInstance StartColumn: 1 StartRow: 1 EndColumn: $”’A”’ EndRow: FirstFreeRowOnColumn – 1 ReadAsText: False FirstLineIsHeader: True RangeValue=> ExcelData
Excel.CloseExcel.Close Instance: ExcelInstance
LOOP FOREACH CurrentRow IN ExcelData
LOOP FOREACH CurrentData IN CurrentRow
DISABLE Display.ShowMessageDialog.ShowMessage Message: CurrentData Icon: Display.Icon.Information Buttons: Display.Buttons.OK DefaultButton: Display.DefaultButton.Button1 IsTopMost: False ButtonPressed=> ButtonPressed
Folder.Copy Folder: $”’D:\テスト\テストA”’ Destination: CurrentData IfFolderExists: Folder.IfExists.DoNothing CopiedFolder=> CopiedFolder
END
END

とりあえずり、試行版