+ Reply to Thread
Results 1 to 6 of 6

Macro to save workbook by referencing cell in another workbook for file name and file path

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    5

    Macro to save workbook by referencing cell in another workbook for file name and file path

    Hi

    I have got a master workbook and I have written macro to copy and paste data on another workbook. I need help to write a macro to save the new workbook to a file path with a file name where both file name and path are stored in master workbook sheet...can anyone help?

    Thanks

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Macro to save workbook by referencing cell in another workbook for file name and file

    Hi AnitaS.

    Post a sample file.
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Registered User
    Join Date
    03-21-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Macro to save workbook by referencing cell in another workbook for file name and file

    Here we go...thanks
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-21-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Macro to save workbook by referencing cell in another workbook for file name and file

    Hi...I manage to corrupt the previous version...here is the updated one
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    03-21-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Macro to save workbook by referencing cell in another workbook for file name and file

    Hi jraj1106, do you think you will be able to help me with this?

  6. #6
    Registered User
    Join Date
    03-21-2013
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Macro to save workbook by referencing cell in another workbook for file name and file

    Does anyone know how to fix this?

+ Reply to Thread

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