WorkBook _SaveAs method help

[suram.sunil]

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

 

[suram.sunil]

I forgot to mention this, I am using MFC.

 

[Norman Jones]

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
'<<=============

 

[NickHK]

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