The code snippet below works under NT, but is failing when I run this in Windows XP:
When I run this, I get the following error:
"Error 1004: Copy method of Worksheet class failed"
Any suggestions would be greatly appreciated.
Code:
'copy current invoice to the master invoice
'workbook, place at beginning of workbook
xlsheet.Copy(xlMasterWorkbook.Sheets(1))
if err.number <> 0 then
MsgBox "Error " & Err.number & ": " & Err.description
end if
"Error 1004: Copy method of Worksheet class failed"
Any suggestions would be greatly appreciated.