Cool!

I finally installed 2007 on the weekend but will be a while until up to
speed with these sorts of things.


Gord

On Tue, 27 Jan 2009 23:32:32 +0100, "Ron de Bruin"
wrote:

I would suggest Excel has no idea what a new unsaved workbook contains.

There is a way to test it in 2007 Gord
This is new in 2007 HasVBProject

See how I use it here
http://www.rondebruin.nl/saveas.htm

Case 52:
If .HasVBProject Then
FileExtStr = ".xlsm": FileFormatNum = 52
Else
FileExtStr = ".xlsx": FileFormatNum = 51
End If