Steve, you said you had checked the Options settings in Excel, but did you
check them in VBA? In VBAOptionsEditor, it the Require Variables
Declarations block is checked, you would have to fully declare all variables,
even if Option Explicit is not declared in the code module.




"Steve McLeod" wrote:

Checked XLSTART. Both System and User. All empty on all machines.
None of use can do anything that writes to the register so by definition it
must be the same.
All users have the same issues.
These were good suggestions, but do not seem to hold an answer.

--
Pictou


"Joel" wrote:

Check the XLSTART directory on the bad machine to see if there are any files
in this directory. Also check if the probelm occurs with more than one user
logged in. There may be some registry differences and it would help to find
out if these differences are against all users or just one user.

"Steve McLeod" wrote:

We have about a dozen XP machines with Office 2003 installed. All but one of
these machines executes our Excel applications without error. One of these
machines produces run time prompts and errors that do not occur on any other
machine. I have checked Options and References. We just reinstalled Office.
The physical machines are the same. All are updated automatically from a
network. All are in a highly secure environment with no connection to the
internet.

I have identified one area as different on the errant machine. This machine
requires that ranges be fully qualified where lesser qualification is fine on
all the others. For example on all other machines the following works:
Range("SheetName!RangeName").Value
On the errant machine I have to use:
Range("'[WorkBookName.xls]SheetName'!RangeName").Value
Also in VBA code, when the workbook in which the range name exists is
active, I can use the shorter version as shown above. But on the errant
machine I must use:
Workbooks("WorkBookName.xls").Worksheets("WorkShee tName").Range("'[WorkBookName.xls]SheetName'!RangeName").Value

Also, on the errant machine when I create a new worksheet from a template,
Excel prompts for a choice to update references and on all other machines
this prompt does not occur.

What could be different on the errant machine? Should we have the network
admin replace the errant machine?

--
Pictou