| |
You are here: Experts > Computing/Technology > Business Software > Using MS Access > Access 2007 runtime and older versions of excel
Using MS Access - Access 2007 runtime and older versions of excel
Expert: Scottgem - 11/6/2009
Question
QUESTION: I have an Access 2007 database with VBA code to transfer specific data to an excel spreadsheet template and save the file after it is populated for importing into another software package. Will this program work on computers with Access 2007 runtime installed that only have excel 2000 or excel 2003. Basically, will every computer running the access program have to be upgraded to excel 2007.
ANSWER: No, the TransferSpreadsheet method in Access doesn't actually use Excel. It simply creates an XLS file.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
---------- FOLLOW-UP ----------
QUESTION: I understand that the TransferSpreadsheet method does not use Excel, I did not word my question correctly. I have programed it to actually open an excel template and place specific data from the database into exact cells using code such as:
On Error GoTo Err_Handler
Dim objExcel As Excel.Application
Dim TheFilename As String
Set objExcel = New Excel.Application
My concern is that I crated this using Access 2007 on a computer that has Excel 2007, but I plan to deploy it using Access 2007 Runtime and I am concerned that if excel 2007 is not installed on the computer then the program will fail.
Answer
Yes that is a different issue. If you are using Office automation then you need to include references to the Excel Object Library in your app. If you use the Office 12 version, then each workstation is going to need that Object library on their system.
I just had basically the same issue today. I added functionality to a client's app to generate an Outlook Task Item when a follow up item is added to the database. I thought that all the workstations had Outlook 2007. But I came in today to find that two machines were crashing on load. I traced it to the fact that there was a missing reference to the Outlook Object Library for Office 12. After I copied the library from a machine using Outlook 2007 into the appropriate folder on the client machine, it worked fine.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
Add to this Answer Ask a Question
|
|
