Are there known incompatibilities between different "builds" of Excel 2002? We're running Microsoft Excel 2002 (10.4524.4219) SP-2 ...
I'm uncertain of what our customer is running, however, they are running Excel 2002.
I did an order form workbook ... when we run it here, on our Excel, it works just as it should. When the customer runs it, it stops, on the following line of VBA:
(more code, to show it in context
Any ideas?
Thanks!
I'm uncertain of what our customer is running, however, they are running Excel 2002.
I did an order form workbook ... when we run it here, on our Excel, it works just as it should. When the customer runs it, it stops, on the following line of VBA:
Code:
Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
(more code, to show it in context
Code:
'Copy the information over to the new workbook (Values, Column Width, Format)
WB2.Activate
Sheets.Add After:=WB2.Sheets("Information")
ActiveSheet.Name = "Order"
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Any ideas?
Thanks!