RE: File manipulation

Hi Chris

Thanks for your question

You can save your file using the saveas method of the workbook object

ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Development\My Documents\" & strFolder & "\" & strFile & ".xls"

strTrust is a folder in mydocuments and strFile is the file name

If you want you can create a folder using the MkDir commmand

MkDir "C:\Documents and Settings\Development\My Documents\" & strFolder

Hope that helps

Regards

Stephen