Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2002 build problem :(
I have written a source code i excel VBA. I have Excel 2002. When I try to
open this wirkbook in older build versions of excel I get an error: Error in compilation hidden module, and error in compilation module1. Are there any way to make a code backward compatible to older builds or anything else that can solve my problem. Ole:) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2002 build problem :(
Ole,
You need to write your code to be compatible with the earliest version of Excel that will be used to open your workbook. There is no "backward compatible" save option. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Ole Einar Ranengen" wrote in message ... I have written a source code i excel VBA. I have Excel 2002. When I try to open this wirkbook in older build versions of excel I get an error: Error in compilation hidden module, and error in compilation module1. Are there any way to make a code backward compatible to older builds or anything else that can solve my problem. Ole:) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel 2002 build problem :(
Ole Einar Ranengen wrote:
I have written a source code i excel VBA. I have Excel 2002. When I try to open this wirkbook in older build versions of excel I get an error: Error in compilation hidden module, and error in compilation module1. Are there any way to make a code backward compatible to older builds or anything else that can solve my problem. Ole:) Start by removing early binding of object variables. Instead of Dim myVar as workbook use Dim myVar as object. This sometimes helps with compatibility problems. Otherwise, in the older version of Excel, open the workbook with the shift key down to prevent autostart procedures from starting. Then open in VBA, set break on all errors, and try either stepping through the code, or hoping that the debugger will properly break on the errors. Q |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help to build a Look Up Function or What Ever Function Excel 2002 | Excel Worksheet Functions | |||
Basic problem with EXCEL 2002 | Excel Discussion (Misc queries) | |||
Iteration problem (Excel 2002) | Excel Worksheet Functions | |||
Merge using Excel 2002 and Hummingbird Docs Open 3.9.0 Build 199 | Excel Discussion (Misc queries) | |||
Problem with Excel 2002 | Excel Programming |