+ Reply to Thread
Results 1 to 12 of 12

I want to saev my excel as PDF format

  1. 12-10-2017, 03:15 AM #1
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    I want to saev my excel as PDF format

    I have this code which saves my excel to a specifies folder with cell value as the file name.

    I want to save it as PDF but the macro allows only .xlsx

    I have tried changing fileformat to PDF but it does not work for me.

    Can anyone please help me

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 12-10-2017, 03:16 AM #2
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: I want to saev my excel as PDF format

    Take a look at ExportAsFixedFormat.
    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.
    Reply With QuoteRegister To Reply
  3. 12-10-2017, 03:21 AM #3
    mike7952
    mike7952 is online now
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: I want to saev my excel as PDF format

    Try recording a Macro and saving a workbook as a Pdf file format

    Please Login or Register  to view this content.
    Thanks,
    Mike

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    Reply With QuoteRegister To Reply
  4. 12-10-2017, 03:35 AM #4
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: I want to saev my excel as PDF format

    Hey mike,

    Thank you so much.

    With the macro is it possible to save the file with the cell value as its file name?

    Because the code which i have allows me to save the file with the cell value as file name .

    is that possible?
    Reply With QuoteRegister To Reply
  5. 12-10-2017, 03:38 AM #5
    mike7952
    mike7952 is online now
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: I want to saev my excel as PDF format

    Yes replace

    Please Login or Register  to view this content.
    with your original code 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 12-10-2017, 03:59 AM #6
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: I want to saev my excel as PDF format

    hey thank you,

    i have got a macro which looks something like this. However nothing is working withy this. Could you please go through it once

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 12-10-2017, 04:05 AM #7
    mike7952
    mike7952 is online now
    Forum Expert mike7952's Avatar
    Join Date
    12-17-2011
    Location
    Florida
    MS-Off Ver
    Excel 2007, Excel 2016
    Posts
    3,520

    Re: I want to saev my excel as PDF format

    I don't see 

    Please Login or Register  to view this content.
    and change 
    Please Login or Register  to view this content.
    to 
    Please Login or Register  to view this content.
    Last edited by mike7952; 12-10-2017 at 04:08 AM.
    Reply With QuoteRegister To Reply
  8. 12-10-2017, 05:02 AM #8
    bakerman2
    bakerman2 is offline
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: I want to saev my excel as PDF format 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 12-10-2017, 05:09 AM #9
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: I want to saev my excel as PDF format

    Hey I am facing some issue.

    I was saving it as PDF only because I dint want people to open my file and change data.

    So i was thinking if i can save the file as read only mode and protect it with password through the vba code which i have.

    the code which I have is 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 12-10-2017, 05:21 AM #10
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: I want to saev my excel as PDF format

    What issue are you facing?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  11. 12-10-2017, 05:36 AM #11
    anilpatni1234
    anilpatni1234 is offline
    Forum Contributor
    Join Date
    08-18-2017
    Location
    india
    MS-Off Ver
    2010
    Posts
    490

    Re: I want to saev my excel as PDF format

    Hey,

    The issue is that it takes too long to save the file.
    I tried changing the file quality but I feel that its better and simpler if i can save the file as "read only mode". because i dont want anyone to alter the data.
    So once i save it then no one can change the data.

    the code which i have is 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  12. 12-10-2017, 05:40 AM #12
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: I want to saev my excel as PDF format

    I've marked your thread as unsolved.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mac converting excel cell formats from general format to date format
    By mrichard in forum Excel General
    Replies: 2
    Last Post: 06-02-2015, 08:42 AM
  2. Excel changes from number format to date format , when ever its closed and reopened
    By burn619 in forum Excel General
    Replies: 0
    Last Post: 01-18-2014, 02:02 PM
  3. Excel:How change the textbox format from text to date format?
    By inpetto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2013, 08:23 AM
  4. Excel: How to convert time format into number format that can be added?
    By Frances Jones in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-17-2012, 04:10 PM
  5. [SOLVED] Excel date format convert to string format
    By man in forum Excel General
    Replies: 1
    Last Post: 08-17-2006, 05:05 AM
  6. [SOLVED] Excel Auto-Format cell to email format
    By Please Help Me in forum Excel General
    Replies: 1
    Last Post: 03-23-2006, 01:20 PM
  7. [SOLVED] How to covert picture excel format to editable excel format
    By SANJUZ in forum Excel General
    Replies: 1
    Last Post: 01-08-2006, 05:30 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1