+ Reply to Thread
Results 1 to 9 of 9

saving to a specific file as workbook is update

  1. #1
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    saving to a specific file as workbook is update

    Below I have a macro to save anytime workbook is update. but i need to edit it to save to a a specific file for ex... D:\picking logs\"

    Please Help



    HTML Code: 

  2. #2
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: saving to a specific file as workbook is update

    guessing no one can solve this.

  3. #3
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: saving to a specific file as workbook is update

    You can probably use SaveAs vrs Save and then designate the Path you want to save it in.

  4. #4
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: saving to a specific file as workbook is update

    how do i write that

  5. #5
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: saving to a specific file as workbook is update

    Sample:

    Please Login or Register  to view this content.

  6. #6
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: saving to a specific file as workbook is update

    since im trying to save it as the name in D1 can i change this workbook.name to Range D1 and get still work.

  7. #7
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: saving to a specific file as workbook is update

    Yes:

    Please Login or Register  to view this content.

  8. #8
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: saving to a specific file as workbook is update

    doesn't work

  9. #9
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: saving to a specific file as workbook is update

    Can you attach a sample? It worked for me when I tested it.

+ 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. VBA Help needed for saving workbook specific folder and file extension ".xlsm"
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2012, 07:50 AM
  2. Saving a File with specific file name using Macro
    By LstarS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2009, 06:13 AM
  3. saving file to a specific folder
    By naomi in forum Excel General
    Replies: 3
    Last Post: 11-15-2007, 04:53 AM
  4. VBA for saving a file to a specific location
    By TimT in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-07-2005, 04:05 PM
  5. Saving a file using a specific name in a cell
    By SU in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-24-2005, 09:06 PM

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