Sorry, Jim. Yes, Excel is visible and the file is open.

| Everything worked great until Monday, which was when we came in to
| work and found Office 2007 on our computers. Now the person who
uses
| this particular routine gets an error every time the code access
the
| Excel file. The code will actually open the file, but will not set
an
| object to the open file. It works great on my machine, but not on
| his.

| For any instance, the code will execute the Workbooks.Open command,
| and the file will open in Excel. But it throws the error in trying
to
| set an object to the workbook that just got opened! And only on
his
| machine!

Ed


On May 21, 10:08*am, "Jim Rech" wrote:
You didn't answer my question re is the workbook visible in Excel before the
Set.

If the user can run Excel there is not likely any corruption.

--
Jim