Hi all!
i am developing a application for accounting purpose using with Visual Basic 6.0 and Access.
then i was export the data's to existing excel workbook. (named Receipts.xls).
now i would like to save the existing excel workbook to another FileName.(i.e backup_receipt.xls)
how can i does like this?.

plz help me!

regards


Muthu

__________________
Muthu

Put this in a module and tie it to form button:

Sub Whatever()
    Dim wbSource As Workbook
    Set wbSource = ThisWorkbook
    wbSource.SaveAs (ActiveWorkbook.Path & "\yourfilename.xls")
End Sub