Will I be able to create/edit a macro template if I have Windows 7 and Microsoft 2010? The company that I work for now has Dev Studio 8007 and Windows 7. We just upgraded from 7.6. When we were using 7.6 I had to use Microsoft 2003 and Windows XP in order to edit an existing macro.

Thanks.

Yes, you can.
You create your Macro Enabled Template in Excel 2010.
In your Fex, when calling the Template you will call it with an xltm extension if it's a simple just populating one tab Template (as below)
ON TABLE PCHOLD FORMAT EXL07 TEMPLATE 'WF8 TEMPLATE.xltm' SHEETNUMBER 1
If you are populating more than one tab the first HOLD will be extension xltm but the subsequent ones will be xlsm. So, in the lines below, I am populating 3 tabs of an Excel Template
...
ON TABLE HOLD AS TEMPLATE1 FORMAT EXL07 TEMPLATE 'WF8 FINAL TEMPLATE.xltm' SHEETNUMBER 1
...
...
ON TABLE HOLD AS TEMPLATE2 FORMAT EXL07 TEMPLATE 'TEMPLATE1.xlsm' SHEETNUMBER 2
...
...
ON TABLE PCHOLD FORMAT EXL07 TEMPLATE 'TEMPLATE2.xlsm' SHEETNUMBER 3

The biggest issue however is that even though it's an Macro Enabled Template, they don't run automatically when it opens.
The only way I have found round this is that if you need them to run automatically, as soon as the Template opens, the Macro's need to be in the subroutine
Sub Auto_Open()

With this comes the catch that if they go and save the template to a new file on their local drive or whatever, every time they open that file, the Macros will all run again because they are on the Auto_Open routine.
Personally, we just have the macro enabled template but have the users manually run the macros upon opening (ours are just formatting macros anyway)

If my original template has a dozen or so pages, (including a macro or two) would I still save it as an .xltm template and add the other data inputs as .xlsm tabs?
Thank you!!
Marilyn