Use Script to Migrate Excel Date

Phishdawg 

In Excel Office Scripts, the save and close methods are not available for workbooks. Instead, the changes made to the workbook are automatically saved.

Regarding your question about performing the same actions across multiple sheets, you can use the getWorksheets method to retrieve all the worksheets in a workbook. You can then iterate over the collection of worksheets and perform the desired actions on each sheet.

Here is an updated example that incorporates iterating over worksheets:

function main(workbook: ExcelScript.Workbook) {
  const sheets = workbook.getWorksheets();
  
  // Iterate over each worksheet
  for (const sheet of sheets) {
    const sourceRange = sheet.getRange('A5:K10');
    const destinationWorkbook = ExcelScript.Workbook.getCurrent();
    const destinationSheet = destinationWorkbook.getWorksheet('<destination-worksheet-name>');
    const destinationRange = destinationSheet.getRange('<destination-cell-range>');

    // Copy data from source to destination
    sourceRange.copyTo(destinationRange, {
      pasteType: ExcelScript.PasteType.all,
      pasteOperation: ExcelScript.PasteOperation.none,
      skipBlanks: false,
      transpose: false
    });
  }
}

Regarding the dynamic nature of the workbook's title, if the only difference is the date, you can use a wildcard character (*) in the file path to accommodate different versions of the workbook. For example:

const destinationWorkbook = ExcelScript.Workbook.open('https://.../Workbook_*');

Make sure to replace Workbook_* with the appropriate wildcard pattern, that matches the title of your workbook.

I apologize for any confusion caused. I hope that I did not end up turning everything into potato salad :).

That's what happens when you want to excel with VBA, Office Script and Java Script at the same time.... the result is potato salad :)).