asked on

Access 2003-2007 conversion

Hello,
I have a question regarding an ACCESS 2003 db that is being used with Offiice 2007. I have Office 2007 and I can access the 2003 db just fine, but when I try to create an excel spreadsheet with relevant data, which is generated by using a template on the network, I get errors. I've tried changing the template to an .xlsm file that has all the security shut off. That didn't work though. For some reason I can't get the activeX controls on the template to load. If I just open up the template, the controls load fine, but when the template is called from code in the Access db, I get errors and the controls won't load. The controls in this case are buttons. Does anybody have any advice on how to mitigate this issue? I'm trying hard not to upgrade the db to 2007. Thanks

Rey Obrero (Capricorn1)

try using .xlt as the extension

Jeffrey Coachman

z018196,

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

Thanks

JeffCoachman

z018196

ASKER

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?

z018196

ASKER

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?

ASKER CERTIFIED SOLUTION

Jeffrey Coachman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

z018196

ASKER

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.

Jeffrey Coachman

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