Need to update multiple columns of excel sheet with date format

[lukasziebold]

I don’t have much time for this today, but you are smart, you’ll figure it out. Here’s the deal:

Follow this instruction to set up a personal workbook and import or code your macro as needed:

Create and save all your macros in a single workbook

In Studio, pick the Excel Application Scope, then add Execute Macro activity within. Edit MacroName like this: "'C:\Users\"+ Environment.UserName.ToLower +"\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB'!" + MacroNameVariable

Second option is to use macro enabled Excel files like this: How to use execute Macro - #10 by aksh1yadav

Invoke VBA code should be straightforward and there are plenty of examples in this forum and elsewhere online.

Good luck!