Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2012
    Posts
    8

    Unanswered: Convert the excel to pdf with respect to sheets

    Hi All,

    i need a access vba code
    on click of the button i need to perform the below task
    I have a folder in which there are many excel files. I want to covert the all the excel file to pdf particularly only the sheet2 and sheet3
    with the same name of the each of the excel workbook in the folder.

    thanks in Prior for any help or suggestions

    Regards
    Kumar

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    and the relevance of this to Access?

    I suppose you could do this from Access VBA, open an instance of Excel, then save each worksheet as a PDF, but why would you from Access?
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2012
    Posts
    8
    Quote Originally Posted by healdem View Post
    and the relevance of this to Access?

    I suppose you could do this from Access VBA, open an instance of Excel, then save each worksheet as a PDF, but why would you from Access?
    No i am creating all those excel file from the access vba so after creating all the excel file its better i convert that in the same code itself.

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    creae a report whichj mimics the spreadsheet and print that to PDF
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •