Hello there, I just bought a book to learn ColdFusion, so I have a project but I wonder if the following is possible:
To create a page where the user can select:
1 - Date Range
2 - Report Name
3 - select to export to Excel, and here is the trick, when the user select the "Export to Excel' buttom, it opens in Excel. So, is possible to make it to open a Template in Excel where I will have a tab with a macro button on it to create a Pivot Table? So, if the user select the report and export it, instead opening in regular Excel, it will open this Template with the macro, and the macro will pick up the data and create a Pivot Table, is this possible in CF? I just started so I just want to make sure that I don't waste my time trying to do it.