I wrote an Excel VBA program for an Excel spreadsheet that acts as the front end for a simple dBbase III database. The user fills in a table on one worksheet of the workbook in order to select the desired records, and the VBA program formats a query which is sent to the database. The returned records are displayed on a second tabbed worksheet. The Excel .xls file resides on a network drive and is accessed by a number of people using different computers on the company network. Of this group of computers, all running Excel 2002, there is ONE which throws the error:
" is not a valid name. Make sure that it does not include invalid characters and that it is not too long.
A fragment of the offending code (no spaces between dBase and III in the first line):
It is this last line that causes the error on only one of 5 different machines.
The query$ is formed correctly. The VBA project references that are checked (including M. Excel 10.0 Obj Lib and DAO3.6 Obj Lib)are identical on all machines. I think DAO3.6 is functional because if unchecked there is another kind of error. The dbOpenDynaset value is identical on all machines.
Does someone have an idea as to why this should fail to run on one specific machine, or any ideas about how to debug this? Wits End!
Bookmarks