+ Reply to Thread
Results 1 to 6 of 6

Macro to save sheet specifik place, with 2 cellvalues as name

  1. #1
    Forum Contributor
    Join Date
    05-20-2015
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    307

    Macro to save sheet specifik place, with 2 cellvalues as name

    To much private info
    Last edited by horsefish01; 04-04-2016 at 07:14 AM.

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Macro to save sheet specifik place, with 2 cellvalues as name

    A macro like this perhaps?

    Please Login or Register  to view this content.
    The only thing I'm not to happy about is the path to your net-disk, don't this disk have a letter designed to it? A macro like this will not work if the "save to" path is not right.


    Alf

  3. #3
    Forum Contributor
    Join Date
    05-20-2015
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    307

    Re: Macro to save sheet specifik place, with 2 cellvalues as name

    To much private info
    Last edited by horsefish01; 04-04-2016 at 07:14 AM.

  4. #4
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Macro to save sheet specifik place, with 2 cellvalues as name

    but already have the filename written?
    To add a number to the file name it must first check if the file name excist an to do so you need the path but now you are saying you are not sure if it's the same fore every one so the add number part is out.

    Try this then:

    Please Login or Register  to view this content.
    Alf

  5. #5
    Forum Contributor
    Join Date
    05-20-2015
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    307

    Re: Macro to save sheet specifik place, with 2 cellvalues as name

    That's awesome @Alf.

    Thanks a lot!

  6. #6
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Macro to save sheet specifik place, with 2 cellvalues as name

    You are welcome.

    Thanks for feedback and rep.

    Alf

+ 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. Macro run on specifik day/time
    By horsefish01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-21-2016, 04:41 PM
  2. [SOLVED] Calculate % of specifik days on sheet.
    By horsefish01 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-28-2015, 04:40 PM
  3. Save(Append) existing cellvalues to comma-separated file
    By kohedin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2013, 04:21 AM
  4. How to get a quote sheet to save to a specific place without taking the macros with it!
    By gramomster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2013, 07:15 PM
  5. Macro that calculates sum of cellvalues across sheets
    By timtim89 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2012, 07:30 PM
  6. macro to place calculation in other sheet.
    By mithil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2010, 07:46 PM
  7. How do I create a macro button and place anywhere on my sheet?
    By Vell H. Holcombe, P.E. in forum Excel General
    Replies: 2
    Last Post: 01-20-2005, 01:07 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