+ Reply to Thread
Results 1 to 4 of 4

Need macros code Update - Excel to PDF

  1. #1
    Registered User
    Join Date
    12-25-2018
    Location
    Abu Dhabi
    MS-Off Ver
    Office standard 2016
    Posts
    28

    Need macros code Update - Excel to PDF

    Good morning all.

    Need small help with my code below, i cant figure it out where do i need to update changes in order to have data saved in PDF format, and how exactly that looks like ?
    Mainly my code is taking data from one of the worksheets and saving it as per department in separated workbooks with all necessary information.

    Thank you all

    Please Login or Register  to view this content.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Need macros code Update - Excel to PDF

    Try this one.
    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Registered User
    Join Date
    12-25-2018
    Location
    Abu Dhabi
    MS-Off Ver
    Office standard 2016
    Posts
    28

    Re: Need macros code Update - Excel to PDF

    Good morning bakerman2.

    It is working perfectly.

    Thank you so much for your assistance.

    Have a nice day.

    Regards from Abu Dhabi

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Need macros code Update - Excel to PDF

    Glad to help and thanks for feedback.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Replies: 0
    Last Post: 06-28-2013, 10:55 AM
  2. Excel or Macros to Update Colors of Cell using Live Calender options
    By pupadhya in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-29-2013, 05:30 AM
  3. Code for getting the Key value from Database and update it in Excel
    By sawoodalam1989 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-28-2013, 06:15 AM
  4. [SOLVED] Code Update for Excel 2007
    By Shermer321 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-20-2012, 03:23 PM
  5. Update PPT charts By Excel Macros
    By nitspari in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2010, 04:37 PM
  6. Importing Excel Macros Code from another Excel sheet which has Macro code.
    By arun.pillai in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-14-2010, 05:38 PM
  7. Extracting Macros and VBA Code from an Excel
    By jdrc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-08-2008, 10:36 AM
  8. [SOLVED] How do I update Excel 2000 macros to work in Excel 2002?
    By BobPetrich in forum Excel General
    Replies: 3
    Last Post: 01-04-2005, 01:06 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