#excel #wsh

change_excel_creation_date.js

var args = WScript.Arguments;

if (args.length !== 1) {
    WScript.Echo("Please drag and drop an Excel file onto this script.");
    WScript.Quit();
}

var filePath = args(0);

try {
    var excel = new ActiveXObject("Excel.Application");
    excel.Visible = false;
    excel.DisplayAlerts = false;

    var workbook = excel.Workbooks.Open(filePath);
    var properties = workbook.BuiltinDocumentProperties;

    properties.Item("Creation Date").Value = properties.Item("Last Save Time").Value;

    workbook.Save();
    workbook.Close(false);
    excel.Quit();

    WScript.Echo("OK");
} catch (e) {
    WScript.Echo("An error occurred: " + e.message);
}