THANK YOU Once again !!!
After few changes I’m able to run this Macro. For learners info: First, Make sure that “Adobe Reader File Preview Type Library” selected in References option in Tools menu. Second, in Adobe Reader => View => Page Display => select “Enable Scrolling”, so that this macro can copy all pages data. Regards Pankaj Sharma From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Michael Vinoth Sent: Friday, May 15, 2015 6:45 PM To: excel-macros@googlegroups.com Cc: polkarnat...@gmail.com Subject: Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require Hi Pankaj Sharma , Thank you for your Appreciation... :) The macro is working fine for me. I attached the Macro and Output Files. I am using MS Excel 2007, Adobe Reader XI and windows 7 (64 bit) combination. Please mention your Excel, Adobe and Windows version to help you further. Let me know if you have any queries. Regards, MV On Friday, May 15, 2015 at 1:00:27 AM UTC+5:30, Pankaj Sharma wrote: Hi MV, Firstly, I want to say thanks for sharing this valuable Macro. People already had given up hope but you have done a great work here. In this macro, getting runtime error in below line:- Invalid procedure call or argument. AppActivate "Adobe Reader And also, if any PDF file have 2/3 pages, only 1st page is copying, need to copy all 3 pages data. Thanks again!!! Regards PJ From: excel-...@googlegroups.com <javascript:> [mailto:excel-...@googlegroups.com <javascript:> ] On Behalf Of Michael Vinoth Sent: Thursday, May 14, 2015 12:31 AM To: excel-...@googlegroups.com <javascript:> Cc: polkar...@gmail.com <javascript:> Subject: Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require Hi Pankaj Sharma , Please find the attached macro file. kindly let me know if you have any queries. Regards, MV On Saturday, May 9, 2015 at 3:01:04 PM UTC+5:30, Pankaj Sharma wrote: i recd 20-30 Mobile Bills in PDF format every month, which i need to copy in Excel with different sheets. That's what i want to make automate. On Sat, May 9, 2015 at 11:21 AM, Pol Ktk <polkar...@gmail.com> wrote: Are you working with cdr ? if s what exactly u need ? On 8 May 2015 at 18:44, Pankaj Sharma <pankaj...@gmail.com> wrote: Please find attached file. On Fri, May 8, 2015 at 5:27 PM, Vabz <v...@vabs.in> wrote: can you share PDF file, if it is text only then same can be imported.. On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote: Hi everyone, Need your help for this easy. I have a folder with multi PDF files. I need a macro to copy all pdf data in a workbook. Note: One pdf data should be copy in one sheet. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com <javascript:> . To post to this group, send email to excel-...@googlegroups.com <javascript:> . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
PDF to Excel Macro.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12
