Please ignore this post. I have discovered that there are issues with access
permissions which I have yet to figure out.

Regards

Glyn Baker

"Glyn Baker" wrote in message
om...
Hi All,

I have a user with Excel 97 and Windows XP. The VBA code was working
fine until the PC was upgraded to XP. I first had a problem in trying
to copy a sheet to a new workbook. I was using the line

Sheets("Quote").Copy

This started to fail. Also, I could no longer copy the sheet manually.
Having searched this forum I have tried all the suggestions about the
name of the sheet object in the VBE and that all looks fine. The
workbook has 10 sheets, some of which are hidden, although the sheet I
am trying to copy is not.

I abandoned the copy sheet idea and decided to copy the cells , create
a new book and paste the data into it. This led to a problem on this
line

Workbooks.Add

This caused the error message "Method 'Add' of Object 'Workbooks'
Failed". Also, once this has occured, I can no longer add a new
workbook manually without exiting from Excel and restarting.

I know the real solution is probably going to be "Upgrade to Excel XP"
but that is not an option at the moment. By the way, this problem is
not restricted to one PC. It seems to happen on any PC with the
combination of Excel 97 & Windows XP.

Any idea's?

Regards

Glyn Baker