I am now trying to paste as values from one worksheet to another. Everything is fine until I use the command:
oXL.Selection.PasteSpecial(-4163)
This returns an error message:
OLE iException code 1004 from Excel
Unable to get PasteSpecial property of the range class.

Any ideas.