Results 1 to 5 of 5

single sheet SaveAs without changing WorkBook FileFormat

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-27-2006
    Location
    United Kingdom
    MS-Off Ver
    EXCEL 2003 (2007 at home)
    Posts
    517

    single sheet SaveAs without changing WorkBook FileFormat

    I wish to save a single sheet from a multi-sheet workbook as "xlTextPrinter"
    to do this I use:
    NewSheet.SaveAs Filename:=fName, FileFormat:=xlTextPrinter
    This works fine, but it sets the name of the entire workbook to fName and also sets the FileFormat for entire workbook to xlTextPrinter.
    At the moment I am recording the workbooks settings prior to saving the sheet, then re-saving the workbook with its original settings.
    This works, but it's rather a cludge, and could cause problems if I have applied some temporary changes to the workbook that I may not want to save.
    Is there any way to save a single sheet without changing the workbook settings?

    Mark.

    PS
    I am using Excel 2003
    Last edited by Mark@Work; 02-26-2009 at 04:46 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1