+ Reply to Thread
Results 1 to 13 of 13

Technical Advice on Printing some sheets on paper but converting one to PDF

  1. #1
    Registered User
    Join Date
    06-24-2014
    Location
    Manchester, England
    MS-Off Ver
    2010
    Posts
    8

    Lightbulb Technical Advice on Printing some sheets on paper but converting one to PDF

    Hi there,

    I'm hoping some of you experts on here can help. I'm not sure if this is achievable and i'm relatively inexperienced on advanced excel details, so here goes.

    We use excel for sales orders, and we need to print hard copies.
    We also have to acknowledge each customer order and currently have to go into a separate sheet and manually add the order info, then save as pdf to email.

    Ideally what i'd like to do is have the acknowledgement auto created from the sales order details. Then as we print the sales order, it auto generates a PDF order acknowledgement that we can send to the customer by email. Perhaps it saves the PDF into a specific folder or to desktop.

    I have experimented by copying cell links from Workbook A to Workbook B, but i have to have both open at the same time in order for the information to auto update.

    if anyone has any suggestions (with instructions) then that would be great. I have used VBA before and can follow instructions on this, i just can't quite figure that out myself as yet.

    Thank you very much in advance!

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    You could use the function below, you might need to modify it for your needs.
    This will publish the worksheet to pass as parameter as a pdf file
    Keep in mnd that the page should be formatted in the layout you want, as if you wre pritning it.

    Please Login or Register  to view this content.
    Last edited by Keebellah; 02-10-2017 at 08:34 AM. Reason: my mistake
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

  3. #3
    Registered User
    Join Date
    06-24-2014
    Location
    Manchester, England
    MS-Off Ver
    2010
    Posts
    8

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    Thank you Keebellah, i really appreciate your quick response on this.

    Can you just talk me through process of putting this into place please.

    Thanks

  4. #4
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    How is your VBA knowledge?
    You could create a worksheet event
    when you right-click on a particular cell that it triggers this funtion:

    Please Login or Register  to view this content.
    Make sue the Function is in a VBA module i that workbook.

  5. #5
    Registered User
    Join Date
    06-24-2014
    Location
    Manchester, England
    MS-Off Ver
    2010
    Posts
    8

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    Hi Keebellah,

    my VBA knowledge is pretty basic.

    But here's what i have done....

    Developer Tab>Visual Basic>Insert Module>Paste in your code above (private sub etc) clicked run, saved as PDF>Exited and then tried right clicking onto the A1 Cell but nothing is happening other than the option to paste.

    Can you help with some guidance pls?

    Thanks

  6. #6
    Registered User
    Join Date
    06-24-2014
    Location
    Manchester, England
    MS-Off Ver
    2010
    Posts
    8

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    Hi Keebellah,

    my VBA knowledge is pretty basic.

    But here's what i have done....

    Developer Tab, Visual Basic, Insert Module, Paste in your code above (private sub etc) clicked run, saved as PDF, Exited and then tried right clicking onto the A1 Cell but nothing is happening other than the option to paste.

    Can you help with some guidance pls?

    Thanks

  7. #7
    Registered User
    Join Date
    06-24-2014
    Location
    Manchester, England
    MS-Off Ver
    2010
    Posts
    8

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    Hi Keebellah,

    my VBA knowledge is pretty basic.

    But here's what i have done....

    Developer Tab, Visual Basic, Insert Module, Paste in your code above (private sub etc) clicked run, saved as PDF, Exited and then tried right clicking onto the A1 Cell but nothing is happening other than the option to paste.

    Can you help with some guidance pls?

    Thanks

  8. #8
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    Something went wrong here is the file and a sample output
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    06-24-2014
    Location
    Manchester, England
    MS-Off Ver
    2010
    Posts
    8

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    yes i think the forum is being updated

    i can't see the attachment. Sorry.

  10. #10
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    They're in my post
    Here they are gain.

    It's about time the database is migratde, it's been a p in the A since a week or two
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    06-24-2014
    Location
    Manchester, England
    MS-Off Ver
    2010
    Posts
    8

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    Hello Keebella,

    thanks so much for your help on this. however i can't seem to get it working. i keep getting an error message.

    Are you able to explain how i put this into a new sheet please?

    Sorry i'm not the best at VBA!

    maybe just some bullet point steps :-)

    Thanks

  12. #12
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    I sent you the sample file.
    There is a module there named mSave2PDF, just copy this module to your file
    If you want to save a particular worksheetas a PDF you just add a macro to do just that, alomost like the code in Sheet1

    A macro couldb:

    Please Login or Register  to view this content.
    This macro will save the worksheet that is active at that moment to PDF.

    I cannot explain more that that, if you do not yet have enough VBA knowledge then you are in for a difficult time asking this type of questions.
    What do you expect? A full course of VBA?

    If you clearly explain what the code is you are using now and what you want to do then maybe I can try and guide you though the steps.
    But again with no VBA knowledge it will be very difficult.

  13. #13
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,900

    Re: Technical Advice on Printing some sheets on paper but converting one to PDF

    Try to Attach a sample file (non-private / non-sensitive data)

+ 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. Printing onto template paper
    By pattpatt1988 in forum Excel General
    Replies: 1
    Last Post: 02-04-2016, 11:49 AM
  2. Printing | Butter Paper
    By vjharry in forum Excel General
    Replies: 2
    Last Post: 02-04-2016, 08:34 AM
  3. printing part of sheet on already printing paper
    By venkat1926 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2016, 08:33 AM
  4. [SOLVED] Advice and technical term for editing data in one cell and it updating in another
    By Mr_Bill in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-18-2014, 10:54 AM
  5. Printing two landscape sheets per side of paper
    By nzbru in forum Excel General
    Replies: 0
    Last Post: 03-10-2013, 03:15 AM
  6. Replies: 2
    Last Post: 10-22-2012, 02:43 PM
  7. Printing multiple excel sheets to the same paper type
    By kalstrai in forum Excel General
    Replies: 0
    Last Post: 06-26-2007, 07:21 PM

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