Hi
I have an Excel VBA macro built in Excel 2000 which runs fine.
However when run on Excel 2002 it throws 'Compile Error in hidden
module....'
I do not have immediate access to a PC with Excel 2002.

The macro uses ODBC access to a remote DB.

The Excel 2002 was the Small Business version that did not have the ODBC
AddIn. However that was located as a Microsoft download and was installed.
It made no difference.

Will much appreciate any suggestions.

TIA

Regards

Dash

Hi Dash,

Can you post the exact error message the Excel 2002 throws?
I would like you to post the code so that I can reproduce and identify the
problem more quickly.

I look forward to hearing from you!


Regards,
Peter Huang
Microsoft Online Partner Support
Get Secure! www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
--------------------
From: "Dash"
Subject: Excel 2002 Compile Error ?
Date: Fri, 22 Aug 2003 09:33:45 -0500
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
Message-ID:
Newsgroups: microsoft.public.excel.programming
NNTP-Posting-Host: cs662557-115.houston.rr.com 66.25.57.115
Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTN GP09.phx.gbl
Xref: cpmsftngxa06.phx.gbl microsoft.public.excel.programming:409154
X-Tomcat-NG: microsoft.public.excel.programming

Hi
I have an Excel VBA macro built in Excel 2000 which runs fine.
However when run on Excel 2002 it throws 'Compile Error in hidden
module....'
I do not have immediate access to a PC with Excel 2002.

The macro uses ODBC access to a remote DB.

The Excel 2002 was the Small Business version that did not have the ODBC
AddIn. However that was located as a Microsoft download and was installed.
It made no difference.

Will much appreciate any suggestions.

TIA

Regards

Dash