Thread: How can I save a single sheet of a workbook using a macro

Wow I am familiar with saving a workbook to almost any format but when it come to saving a single sheet I'm a noob!!!

Someone please save me hours futile future searching, after hours of already searching by answering how to do something so simple in a macro!

All i want to do is save one sheet (of a workbook that has many sheets) to a specific location in my hard drive.

I was using the

Code:

    Sheets("sheet").Copy

    ActiveWorkbook.SaveAs Filename:= _
        "C:\sheet.xls", FileFormat:= _
        xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
        , CreateBackup:=False
        ActiveWorkbook.Close

untill i found out it was cutting off characters over a certain length in the cells.

does not :

Code:

     Worksheets("sheetname").SaveAs Filename:="c:csvip.xls", _
       FileFormat:=xlExcel4

or

Code:

    Activeworksheet.SaveAs Filename:= _
        "C:sheet.xls", _
        FileFormat:=xlNormal, CreateBackup:=False

I can't seem to get anything to work!

Welcome to the forum, prouddad.

Please read the forum rules about thread titles, and then amend yours accordingly.

Also, when reviewing the rules, please pay attention to the one about cross-posting.

http://www.mrexcel.com/forum/showthread.php?t=381704

You haven't bothered reading the rules because you would see that cross posting means posting the same question on different forums with a link. You will find this applies to Mr Excel as well!