Andy wrote :
The template is essentially a form based spreadsheet system for users to
submit various types of data and so it makes sense to be built in Excel. The
Outlook section is only a tiny part of the code, used to simply "download"
another version of the template.

I'm just trying to encompass everything in the same workbook. I've done
something similar before and it worked perfectly. It only seems to be the
different version of Office issue that throws a spanner in the works.

Doesn't sound to me that you're implementing normal use of an Excel
template. Not sure what you mean by "download" another version of the
template but templates are used to either insert worksheets into an
open workbook OR open a new workbook based on the template. Perhaps you
need to review the ActiveWorkbook.Sheets.Add method OR the Template
parameter of the Workbooks.Open method!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion