I am having trouble using the SaveAs method of the workbook class. Can
someone please tell me how to use this method.
Thanks,
Sunil

I forgot to mention this, I am using MFC.

wrote:
I am having trouble using the SaveAs method of the workbook class. Can
someone please tell me how to use this method.
Thanks,
Sunil

Hi Suram,

Try something like:

'=============
Public Sub Tester()
Dim WB As Workbook
Const myPath As String = "C:\Data\"
Const sName As String = "ABC"

Set WB = ThisWorkbook

WB.SaveAs Filename:=myPath & sName & ".xls", _
FileFormat:=xlWorkbookNormal
End Sub
'<<=============


---
Regards,
Norman



wrote in message
ups.com...
I forgot to mention this, I am using MFC.

wrote:
I am having trouble using the SaveAs method of the workbook class. Can
someone please tell me how to use this method.
Thanks,
Sunil

No idea what your "trouble" is, but I have had difficulties using .SaveAs
with non-ANSI letters in the path/filename on English systems, whereas
..SaveCopyAs works always.

NickHK

wrote in message
oups.com...
I am having trouble using the SaveAs method of the workbook class. Can
someone please tell me how to use this method.
Thanks,
Sunil