Access 2003-2007 conversion

try using .xlt as the extension

z018196,

Can you give us some details on these "Errors"?

Thanks

JeffCoachman

Thanks for your responses.  The initial template I was using had an .xlt extension.  I think the issue has to do with Access 2003 being used on a PC with Office 2007 installed.  I don't know if the problem comes as a result of Excel 2007 being called from an Access 2003 db?  The error that comes up says that the ActiveX controls can't load, which are the buttons on the template.  There is another error that says the code behind the button won't load either. The template has built in functionality which is run by the buttons.  I tried creating the same template in Excel 2007 and enabled all the activeX controls, macros, etc.  I can open the file fine just using Excel, but when the file is opened through code in the Access 2003 db, the security settings don't seem to hold.  Any additional thoughts?

Here is where my issue occures
(Within a 2003 Access DB) Opened with a PC that has both Office 2003 and Office 2007 installed

Dim xlApp As Excel.Application
Dim xWorkbook As Excel.Workbook
Set xlApp = New Excel.Application
Set xWorkbook = xlApp.Workbooks.Add(path/template.xlt)
and I've also tried
Set xWorkbook = xlApp.Workbooks.Add(path/template.xlsm)

The excel document has some controls on it(buttons) that have functionality to amend the worksheet.  An error is generated saying that the ActiveX controls are unable to load.  Is there a way to bypass this error and have the controls load?

Thanks Jeff,
The ActiveX controls are on the worksheet, for the purpose of data munipulation once the worksheet is created.  I think I may just have to go ahead with the 2007 conversion then.  Thanks for your comments.  

OK,

But please keep in mind that using VBA (ActiveX) controls on the sheet always causes problems, because these type of controls were designed to be used in VBA "Userforms", not worksheets.

So the same issues, or more, might develop in 2007.

:-)

JeffCoachman