Avatar of z018196

asked on 

Access 2003-2007 conversion

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  
Microsoft OfficeMicrosoft AccessMicrosoft Excel

Avatar of undefined
Last Comment
Jeffrey Coachman
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

try using .xlt as the extension

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


Avatar of z018196


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?
Avatar of z018196


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?
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of z018196


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.  

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.


Microsoft Access
Microsoft Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo