+ Reply to Thread
Results 1 to 6 of 6

macro to just automatically open the pdf file in a location and copy it and paste in XL

  1. #1
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    macro to just automatically open the pdf file in a location and copy it and paste in XL

    Dear Sir

    Good Morning guys

    Can any one plz show interest in my thread guys

    Through my extensive search ,I came to know that there is no macro available to convert directly from pdf file to excel.It can be accomplished only by a software.
    As external software is not allowed in our system in our institution,it would be very helpful if any body can provide macro just only for opening the pdf file ,copy it and paste the content in my excel sheet.It does not matter to preserve the format of the pdf and its enough to copy the text very importantly and paste in the excel sheet.

    Though it can be done manually ,our work involves a lot of pdf files which we will put in excel sheet for processing them

    Thanking You
    Last edited by catchnanan; 03-11-2018 at 04:22 AM.

  2. #2
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Re: macro to just automatically open the pdf file in a location and copy it and paste in

    Dear Sir

    Can any one help to solve my thread

    Narayanan

  3. #3
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Re: macro to just automatically open the pdf file in a location and copy it and paste in

    Hai can any one give solution to my post

  4. #4
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Re: macro to just automatically open the pdf file in a location and copy it and paste in

    Dear experts

    Still hopefully waiting for your kind attention to my thread

    Thank you

  5. #5
    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,869

    Re: macro to just automatically open the pdf file in a location and copy it and paste in

    There are reasons why you have had no response. For starters, you have provided no sample PDF file. How is anyone to help without one? Nor have you provided a sample Excel workbook showing how you would expect the contents of the PDF file to look.

    If you really expect help, then take the hint (no replies so far) and provide more for your potential helpers to work with.
    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.

  6. #6
    Forum Contributor
    Join Date
    07-07-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    256

    Re: macro to just automatically open the pdf file in a location and copy it and paste in

    thanks madam....it is just an ordinary 2 pages pdf with tables. i am hopefully looking forward..

+ 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: 8
    Last Post: 11-25-2015, 08:14 PM
  2. [SOLVED] [Help]macro to open file browser, to select a location, and save the location to a cell
    By zhuleijia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2013, 09:56 AM
  3. [SOLVED] open variably named file, copy/paste data into consolidation file, open next file in list
    By sllawrence1968 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-29-2012, 09:49 PM
  4. macro to open, copy paste from existing excel file to a new blank file
    By 2blessed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2012, 06:05 PM
  5. Copy, open file, and paste macro
    By Ohaern in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2011, 11:45 AM
  6. macro to open file - copy - then paste into other file possible??
    By Kezwick in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-13-2011, 07:59 AM
  7. Open Separate File, Copy Data and Paste Macro
    By boohah in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-31-2010, 02:04 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