Please Help - Macro Error for 2003 User

[Illryion]

All -

Thanks for the help. I have a sheet designed in Excel 2010 which I have distributed to a number of users, using 2003, 2007 and 2010. Most users are able to work without a problem, but I have a couple of 2003 users having an issue with a Print Macro.

The Macro is a simple one -

Sub PrintQuote()
'
' PrintQuote Macro
'


'
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False
End Sub

For the users having an issue, when they press the button associated with this Macro - they receive the following error - '((#REF.xls could not be found. Check the spelling of the file name, and verify that the file location is correct.

When they go to run the Macro manually - they receive - "Compile Error: Named argument not found."

Help? Any idea on what's different between users?

 

[par60056]

They are probably using a different printer. It does not support a Collate argument.

 

[Illryion]

I removed the Collate argument from the macro - no dice. Any other ideas?

 

[par60056]

Hate shooting in the dark. But I'll fire another round.

If it isn't a difference in the printer, then it has to be something in the sheet itself.

What happens if you simply hit the print button on their computer? If that is all the code in the macro there is not much that can be wrong.

The error message seems to indicate that there is something on the sheet that is referencing another XLS workbook. Is it possible that there is a network drive mapping that is not lining up so that they are not finding it?