Edit an excel template

[jacquij123]

Hi,

A while ago I created a report in SIMS that outputs to an excel spreadsheet with Macros that work automatically when the report runs. I've copied this report but need to edit the template but am completely stuck! can't even remember where I saved the template. But if I do find it I need to edit it but keep the original for the original report. Can anyone help please. Thankyou

[Esteban_Child_of_the_Sun]

You can extract the template with macros from SIMS. Just export the report as a .RptDef file and rename it to .zip then extract the excel file within the zip file.