Skip navigation
Currently Being Moderated

Save as PDF file as excel file or text file in vba excel

Apr 10, 2012 6:20 AM

Hi all,

 

I am opening a PDF document fromm VBA excel. After opening document it should save the document as excel file or text file in one folder.

I am trying to do this with some code but not able to , pls help me thatnks.

 

Dim AcroApp As Acrobat.CAcroApp

  Dim Part1Document As Acrobat.CAcroPDDoc

Set Part1Document = CreateObject("AcroExch.PDDoc")

   Part1Document.Open ("Z:\EG MI Information\MIS\Requests\Req_156\NO.1.pdf")

 

 

  Dim app As Object, avdoc As Object, pageview As Object

Set app = CreateObject("AcroExch.App")

Set avdoc = app.GetActiveDoc

app.MenuItemExecute ("SaveAs")

 
Replies

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points