+ Reply to Thread
Results 1 to 2 of 2

Can't get it (macro) to repeat

  1. #1
    Registered User
    Join Date
    06-29-2013
    Location
    Washington State
    MS-Off Ver
    Excel 2011
    Posts
    3

    Can't get it (macro) to repeat

    Trying to get a file to save via a macro using data in a cell for the name of the file.

    Example:
    Use concatenated data in A16 as the file name during an macro initiated "save as" runs.

    I can record it. It works the first time, but when I run subsequent "runs" after changing the data that concatenates in A16, it keeps coming back with the data from the first save... it never "updates" to the new data...

    Any ideas why it is not working?

  2. #2
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    882

    Re: Can't get it (macro) to repeat

    With the limited info about filepaths, file types etc. try...
    Please Login or Register  to view this content.
    or bit better
    Please Login or Register  to view this content.
    Last edited by WasWodge; 07-12-2013 at 10:22 PM.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

+ 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