what's wrong with this, I open a workbook copy some stuff from it to a different workbook. I want to close it without saving it.
[VBA]
wkbsource.Close
With wkbsource.Close
.Save = False
End With
[/VBA]
what's wrong with this, I open a workbook copy some stuff from it to a different workbook. I want to close it without saving it.
[VBA]
wkbsource.Close
With wkbsource.Close
.Save = False
End With
[/VBA]
[vba]
wkbsource.Close SaveChange:=False
[/vba]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
xld, it said named argument not found
oh ok, it's savechanges:=false
thanks
Sorry, if I had plugged it into a macro I would have seen that :-)
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
thanks a lot