RE: Excel & MS Query caused compile errors

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You didn't specify what happened to cause the problem. did you perform any
updates to windows, Office, or other products that may of caused the cahnge.
Do yo uhave your window updates set in automatic update mode or did your MIS
department push some updates on your PC?

I suspect one of the DLL got updated.check the References in the VBA menu
tools - References and see if any of the select libraries got updated.

"Simon Shaw" wrote:

Hi,

After connecting to BusinessVision tables and returning data to Excel, my
VBA code in excel suddenly became un-compileable. Simple code syntax such as
declaring a variable was suddenly invalid. I would comment out the offending
lines to see what else failed, and stopped after about the 12th code failure.

The code compiles fine in numerous environments and runs in Excel 2000, 2003
& 2007 against Pervasive, MS Access, SQL Server, My SQL and Oracle databases.

The error occurs just after manually querying BusinessVision 7.3 with
Pervasive 10 database with Excel for the first time.

Fix Attempts include:
- Uninstalling/re-installing Excel
- removing and adding the System DSN files in the ODBC Drivers
- uninstalling BusinessVision and pervasive
- applying all updates to Excel, BusinessVision and the OS.
none worked

I then started with a clean windows server, installed excel, then installed
BusinessVision. the VBA code still compiled. I then added the System DSN
file. the VBA code still compiled fine. I then performed a manual database
query to retrieve data from the AR - Transaction tables, which was
successful. I then tried to compile the VBA code and it failed - miserably...
:(

thoughts?

Thank you!

--
Simon Shaw, CA | President | Kode101 Inc.
www.kode101.com
.

Relevant Pages

  • Excel & MS Query caused compile errors
    ... After connecting to BusinessVision tables and returning data to Excel, ... VBA code in excel suddenly became un-compileable. ... The code compiles fine in numerous environments and runs in Excel 2000, ...
    (microsoft.public.excel.programming)
  • RE: Excel & MS Query caused compile errors
    ... My data is in an Excel file and I'd like to fill a column within this file. ... Do yo uhave your window updates set in automatic update mode or did your MIS ... After connecting to BusinessVision tables and returning data to Excel, ... VBA code in excel suddenly became un-compileable. ...
    (microsoft.public.excel.programming)
  • Interpreting and merging an outdated LMS with Project
    ... All updates to schedule, cost, charging, etc. are input directly into the ... I've got several Excel queries, VBA-bastardized macros, etc. ... that strip and format the data that I need from these massive .dbf's. ... My areas have 6,000+ individual workpackages ...
    (microsoft.public.project)
  • Re: Excel Autorecover - Help Please
    ... One problem I have noticed is when Excel crashes, ... And reinstalled Office X (I have to use b/c I use budgeting software ... you may have problems with disk ... AutoUpdate or by downloading and applying updates from ...
    (microsoft.public.mac.office.excel)
  • RE: ALL EXPERTS ........... WHERE ARE YOU ??
    ... that if someone sees MVP next to a name in a reply that they may assume I ... MVP or otherwise really sharp Excel person, I figure things are in good hands. ... VBA code is set aside and the file opens. ... I would like to know whether this is not possible or there is a bug in the ...
    (microsoft.public.excel.misc)