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

Avatar of undefined
Last Comment
Jeffrey Coachman

8/22/2022 - Mon
Rey Obrero (Capricorn1)

try using .xlt as the extension
Jeffrey Coachman

z018196,

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

Thanks

JeffCoachman
ASKER
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?
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
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?
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
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.  
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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.