Hi,

I'm using this macro :

Dim vFilename
vFilename = "Export Q 1.0 " & Worksheets
("Export").Range("A2").Value & ".xls"
ChDir "C:\"
ActiveWorkbook.SaveAs Filename:=vFilename,
FileFormat:= _
xlNormal, Password:="", WriteResPassword:="",
ReadOnlyRecommended:=False _
, CreateBackup:=False
ActiveWindow.Close

The problem is that the file is not allways saved on c:

Is it possible to save it allways on C:
Or is it even possible to save in on C:\XXX.
Can be checked If c:\XXX exists ? If not create C:\XXX ?

Thanks !
Tom