excel 2002 build problem :(

  • Thread starter Thread starter Ole Einar Ranengen
  • Start date Start date
O

Ole Einar Ranengen

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:)
 
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 said:
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:)
Click to expand...

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
 
Back
Top