+ Reply to Thread
Results 1 to 8 of 8

Auto Save

  1. #1
    Registered User
    Join Date
    06-14-2018
    Location
    LONDON
    MS-Off Ver
    2007
    Posts
    29

    Auto Save

    Hi Could anyone help me please? im trying to make my excel workbook faster to use so i want to be able ideally to click one/ two buttons to save only one sheet as a pdf & type out the email body "Hello,
    Please find the quote attached" & subject"Quote" & upload the pdf.But i want to enter the email address myself.

    Additionally id like to save just the active worksheet again as a excel workbook. With the file name coming from m1.


    My biggest problem is I dont know how to only get the macro to make the pdf & single worksheet to save as page 1 cells A1:I4 on the "quote" sheet as theres other stuff I dont want to be on these. What I have so far is:



    Please Login or Register  to view this content.
    So as you can see I want the PDF to be saved in: C:\Users\John\Desktop\Blank Cost Sheets\AUTO QUOTE PDF
    Also id like the worksheet to be saved in: C:\Users\John\Desktop\Blank Cost Sheets\AUTO QUOTE

    I really dont know what im doing. I just found this code online and have spend a while trying to make it work for me. Thanks

    Also I think I’ve posted the code correctly but it’s not easy on my phone
    Last edited by chris1888; 07-06-2018 at 06:00 PM.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Auto Save

    Hi chris1888

    In future please view the forum rules before posting. Your post does not comply with rule #3.
    3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing.
    So, do the following:
    Edit your post, highlight your code and click the [#] button at the top of the post window.
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Auto Save

    Thank you chris1888

    Give this a go ... change to your path
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-14-2018
    Location
    LONDON
    MS-Off Ver
    2007
    Posts
    29

    Re: Auto Save

    Hi Sintek,

    I Appreciate the help. Im getting a "subscript out of range" error. When I click ok it opens up a new workbook called book1. Any ideas whats going wrong here? Am I doing soething wrong?

  5. #5
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Auto Save

    Upload your file sample...so that we can see your use of the code...
    Last edited by sintek; 07-09-2018 at 07:30 AM.

  6. #6
    Registered User
    Join Date
    06-14-2018
    Location
    LONDON
    MS-Off Ver
    2007
    Posts
    29

    Re: Auto Save

    This is the code i entered, I presumed that I needed to change the file1 & file2 part as I couldnt see how it would find the file location.
    See the attached, I had to delete a few bits of data but should be okay.

    Ive linked this \/ to the save as button on the last sheet "quote"
    Please Login or Register  to view this content.

  7. #7
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,122

    Re: Auto Save

    Please Login or Register  to view this content.
    So they are to be saved to desktop in subfolder Auto Quote within folder Blank cost sheet???
    Last edited by sintek; 07-09-2018 at 09:26 AM.

  8. #8
    Registered User
    Join Date
    06-14-2018
    Location
    LONDON
    MS-Off Ver
    2007
    Posts
    29

    Re: Auto Save

    Yes please

+ 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. Save, Date, Rename File and Auto Save
    By COURTTROOPER in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-09-2017, 05:16 AM
  2. Macro to auto-save and auto-close workbooks after a certain time?
    By Hambone70 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-14-2017, 02:17 PM
  3. Vehicle Sign Out Log - Auto Save, Auto Date & Time
    By ccalangi in forum Excel General
    Replies: 0
    Last Post: 01-21-2015, 09:16 AM
  4. macro to bring up stored workbook, auto save to a new folder, then auto fill
    By Rick23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-29-2014, 06:58 PM
  5. Macro to Auto save a backup copy in a seperate location OR save file with a pop up
    By kdsanderson30 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-12-2014, 12:38 PM
  6. Replies: 1
    Last Post: 01-12-2006, 06:20 PM
  7. Auto Excel workbook close: save= false during an auto subroutine
    By tomwashere2 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-16-2005, 02:05 AM

Tags for this Thread

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