runtime error 1004 excel

Sounds like the spreadsheet has a flawed piece of VB code written into it. If the user knows where he/she got the spreadsheet, half the problem is solved. Allow the originator to fix it, or read more here

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sdbug/Html/sdbug_9.asp

Runtime error 1004 is a general error that says an method of an object is not being used or referenced properly. When you get the error, hit the help key and it will give you an explanation.

Here are a couple of possibles:

Run-time Error '1004' Accessing Locally Defined Name

http://tinyurl.com/2qbc

Cannot Use Page Setup Property If No Printers Installed

http://tinyurl.com/2qbd