+ Reply to Thread
Results 1 to 3 of 3

VBA code to save excel file to PDF under the current name of workbook.

  1. #1
    Forum Contributor
    Join Date
    11-21-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007,2013
    Posts
    159

    VBA code to save excel file to PDF under the current name of workbook.

    Hi,

    I have code below but seems not working. Any can possibly fix this code. I record this in macro with intention to save the excel file under current name of workbook in the desktop.

    Please Login or Register  to view this content.
    Last edited by reimar_rem; 07-03-2018 at 04:08 AM.
    Click * below if this answer helped

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,212

    Re: VBA code to save excel file to PDF under the current name of workbook.

    You should put code inside # as per the forum rules, as this makes the code easier to copy and easier when you get given solutions. But I think fullname includes the path to the file, so changing it to name should solve your problem.

    Please edit your original post

  3. #3
    Forum Contributor
    Join Date
    11-21-2013
    Location
    Philippines
    MS-Off Ver
    Excel 2007,2013
    Posts
    159

    Re: VBA code to save excel file to PDF under the current name of workbook.

    Hi,

    Thanks. I have already edited.

    Thank you its working perfectly.

+ 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. [SOLVED] VBA code to browse for external excel file and extract its all sheet to current workbook
    By mchilapur in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-11-2016, 04:05 AM
  2. In Current workbook- copy sheets from other workbooks and save in current workbook
    By johnnywinter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2016, 08:41 PM
  3. Save the current worrkbook, save the sheet as .csv and close the workbook
    By SpeediWeb in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-10-2015, 06:50 AM
  4. [SOLVED] VBA code to save current worksheet as temporary PDF file and then add to my existing code
    By brianfromla in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-20-2014, 08:35 AM
  5. Converting excel 2003 file ext macro file-save code to reflect excel 2007 exts
    By pmanoloff in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-20-2013, 12:17 PM
  6. Modify Current VBA Which i Use To Save Excel 2010 File to CSV
    By magnum4u in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-07-2013, 10:39 AM
  7. Save excel file as current date
    By webbey21 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2005, 11:06 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