I know sp_makewebtask can output results into a .xls file. What I'd like to do is create an .xls template file with the <%insert_data_here%> tag. When I place the tag in the contents of a cell, sp_makewebtask does not recognize the tag.
Can I use the <%insert_data_here%> tag in a .xls template file?