I don't speak the Access, but my first bet is that you have an error in your
code.

If you post the snippet of code causing the problem, maybe someone will jump in.

Bob Barnes wrote:

I'm an Access Programmer used to using "Tools - References" in Access.

We are a large Company where all Office 2003 Installations are done by
the IT Dept. On one Excel setup, strange things happen (IE - automation
VBA from Access-to-Excel doesn't work when assigning a value to a Named
Range.

Are there "Tools - References" in Excel, or something in an Incomplete
Install, where things like the above could happen?

TIA - Bob

TIA - Bob

--

Dave Peterson