transferspreadsheet does not work

[Marcia]

I created a macro that uses the transferspreadsheet to
export information to an existing Excel file. It then
continues on to open that file and execute a macro that
sends the user straight to the print preview.

This works fine in Office 2000 but when I try to run it on
2003 it does not transfer the file. It does open Excel
but with the old info and it does not go into the print
preview.

The files keep showing up as read-only. Even when I take
that attribute off, it comes right back.

Help,
M