Hi Shawn
Thanks very much that worked. Now I like to know how ?
All documention and examples seemed to be along the lines
of the following
.SaveAS Filename:=(FilePath), FileFormat:=xlNormal
How does -4143 equate to xlNormal
If you run the Macro recorder in Excel you will see.
Thank again Gary