Problem with simple macro that works in 2003 not 2000?

[Pauljj]

I am using this code, which works perfectly for 2003

Sub CSVLBAFEB()
'
' CSVLBASEP Macro
' Macro recorded 14/09/2006 by Paul Hailes
'

'
Columns("FD:FF").Select
Selection.Copy
Workbooks.Add
Columns("A:A").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Selection.PasteSpecial Paste:=xlPasteColumnWidths, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
ChDir "L:\Payroll"
ActiveWorkbook.SaveAs Filename:="L:\Payroll\LBAFEB07.csv", FileFormat:=xlCSV _
, CreateBackup:=False
End Sub




It seems to fail on the pasting of column Widths, even when i try to record a macro, by copying and pasting widths it fails? I dont understand...does anyone else ?

 

[erik.van.geit]

Thank you, Ivan,
this saved me an installation of 2000

this was not clear to me:

xlpastevalidation = NO CONT it is infact

did you mean it is no constant ? it is in the list in the helpfiles

best regards,
Erik

 

[Ivan F Moala]

Thank you, Ivan,
this saved me an installation of 2000

this was not clear to me:

xlpastevalidation = NO CONT it is infact

did you mean it is no constant ? it is in the list in the helpfiles

best regards,
Erik

Sorry Erick for not been clear.

What I meant is that the xlpastevalidation is not defined as a constant in Xl2000, it is actually xlDataValidation BUT this bugs out too.

 

[erik.van.geit]

OK, thanks, Ivan

to be clear at 100% for future reference of other members which might stumble in to this thread
when I was talking about the helpfiles

it is in the list in the helpfiles

it is not about version 2000 but xl2003

best regards,
Erik