+ Reply to Thread
Results 1 to 2 of 2

What is the best way to use a macro to save a worksheet separate

  1. #1
    Registered User
    Join Date
    02-05-2014
    Location
    canada
    MS-Off Ver
    Excel 2007
    Posts
    17

    What is the best way to use a macro to save a worksheet separate

    Hello


    I'm attempting to save a worksheet separate from my worksheet. I started a simple macro where as soon as I start recording, I right click the worksheet and "make copy in a new workbook." This works well enough, but I would like to set the macro up to automatically save the worksheet using designated text as the worksheet file name.

    For example:

    I copy a worksheet into its own workbook. In cell A1 of that worksheet the title is "Budget"

    How do I get the macro to recognize whatever the text is in cell A1 and then save it as the file name and onto my desktop?

    The title of my worksheet will change often.

    Is it possible to use the macro to recognize ANY text so long as it is within the designated cell, ( A1 ) ?

    Also, I have some formulas in this new worksheet which is now saved separately into it's own workbook. Is it possible to erase the formulas yet still leave the data?

    Thank you!
    Last edited by Ephy; 08-06-2014 at 07:22 PM.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: What is the best way to use a macro to save a worksheet separate

    Please Login or Register  to view this content.
    Is it possible to use the macro to recognize ANY text so long as it is within the designated cell, ( A1 ) ?
    You can't use slashes and there may be other forbidden characters.

    Also, I have some formulas in this new worksheet which is now saved separately into it's own workbook. Is it possible to erase the formulas yet still leave the data?
    You can copy the data and paste special values to obliterate the formulas and there are probably other ways
    Last edited by xladept; 08-06-2014 at 07:31 PM.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to save Worksheet as separate Workbook?
    By Alexb77 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-11-2014, 05:20 PM
  2. Separate and save active worksheet
    By Garysmith in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-26-2014, 12:51 PM
  3. [SOLVED] Save worksheet to separate file with no macro buttons & no connections to original
    By kopapa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-04-2013, 05:53 AM
  4. Generate data and save in separate worksheet
    By cgithu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2012, 07:38 AM
  5. Save Worksheet As A Separate File Using Cell Name
    By jasono in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-02-2011, 12:18 PM

Tags for this Thread

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