+ Reply to Thread
Results 1 to 4 of 4

Save as specific path and name

  1. #1
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    2010
    Posts
    383

    Save as specific path and name

    Hello,

    I would like to create a Marco button that would allow me to save the "PROFORMA" sheet in the path defined in J6 with the following format =CONCATENATE(J8;"_";J9;"_";J7)

    [COMPANY]_[EVENT]_[DATE] so it should read like: company01_World mobile_24.03.2013

    So the attach fie will be the "master" file that should not be saved.

    Many thanks,
    Graig
    Attached Files Attached Files

  2. #2
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,098

    Re: Save as specific path and name

    Hi, Graig,

    maybe like this:
    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  3. #3
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    2010
    Posts
    383

    Re: Save as specific path and name

    Thank you so much Holger! It works perfectly well and gave me what I was expected :-D Many Thanks!!!

  4. #4
    Forum Contributor
    Join Date
    02-21-2007
    MS-Off Ver
    2010
    Posts
    383

    Re: Save as specific path and name

    As You provided me with the correct answer I would like to know if there is a way from the previous macro or by creating another button to save the file the same way as we did before but as pdf file and to print the document out only the sheet2 out?

  5. #5
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2013 on Win10 (desktop), 2007 on Win10 (notebook)
    Posts
    8,098

    Re: Save as specific path and name

    Hi, Graig,

    please note that the Ranges are taken from the active Sheet, you may have to reference them with the sheetname if its not the active sheet these data are on. Please change the sheet name to be printed to suit (Im using a local german version so my second sheet is called Tabelle2 or refer to Sheets(2) the second sheet in the order from left (may also be a chart sheet) or Worksheets(2) which is the second worksheet from left). And yes, I used the preview function:
    Please Login or Register  to view this content.
    Ciao,
    Holger

+ 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