I have a VB application which opens some template files stored on a network share which were originally made in word basic. After upgrading to Office 2007 these do no work as expected and always throw an error maessage saying "Sub or Function not defined" Can anybody help me out please?
I think you need a service pack with some old libraries supported.. This is quite common when upgrading to higher levels of VB.. eg 3 to 5 or 6 etc. If you have the un-compiled code, it can be fixed.. Or load an early version of VB will also fix it. If you have the code, send it to me. Let me know how it goes.. Rgds,
Excel Workbook
.xlsx
The default Excel
file format. Cannot store VBA macro code or Microsoft Excel 4.0 macro sheets
(.xlm files in Excel 4.0).
Excel Macro-Enabled
Workbook
.xlsm
Uses the same basic
XML format as the Excel Workbook, but can store VBA macro code. Users saving
an Excel workbook that has VBA code or Excel 4.0 macro sheets (.xlm files in
Excel 4.0) are prompted to use this file format.
Excel Template
.xltx
The default file
format for an Excel template. Cannot store VBA macro code or Excel 4.0 macro
sheets (.xlm files in Excel 4.0).
Excel Macro-Enabled
Template
.xltm
Can contain a
VBAProject part or Excel 4.0 macro sheets (.xlm files in Excel 4.0).
Workbooks created from this template inherit the VBAProject part or Excel 4.0
macro sheets that exist in the template.
Excel Add-In
.xlam
A supplemental
program that runs additional code. Excel add-ins use the Open XML file format
to store data, and they support using VBA projects and Excel 4.0 macro
sheets.
74 views
Usually answered in minutes!
×