Hi Umesh,
I am working on data containing Authorized signatory list and wanted this data on excel. I have all data in pdf version and need to get this on excel. In order to get this done I need your help to get vba coding for the converting pdf data to excel data. Kindly confirm if below code is ok to run and get the desired result as this will save lot of manual effort to get data. Thanks a lot for your help. Regards, Vikram Ahuja From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Umesh Dev Sent: Thursday, January 27, 2011 12:58 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help Required Hi Vikram, I clearly did not understand your query, however I have rectified the code. Regards Umesh Dev On Wed, Jan 26, 2011 at 9:32 PM, vikram <vikramahuj...@gmail.com> wrote: Hi Umesh, Thanks a lot for your help. I need one more help regarding below macro for converting PDF files to excel .Below macro coding is showing error while running this macro as I have to convert around 100 pdf files to excel and for your reference I have enclosed one of the PDF file. Kindly help in this regard. Sub BackToA1() Range("A1").Select End Sub Sub GetPDFnow() Dim varRetVal As Variant, strFullyPathedFileName As String, strDoIt As String 'Add a new worksheet Sheets.Add After:=Sheets(Sheets.Count) 'Name it ActiveSheet.Name = "Input01" 'Back to "A1" Range("A1").Activate 'HERE YOU DEFINE THE FULLY PATHED PDF FILE strFullyPathedFileName = "C:\Documents and Settings\ayujain1\Desktop\Excel_Tutorials\Ayush ebooks\14 secret shortcuts of Excel.pdf" 'HERE YOU SET UP THE SHELL COMMAND strDoIt = "C:\Program Files\Adobe\Reader 9.0\Reader\AcroRd32.exe " & strFullyPathedFileName 'The Shell command varRetVal = Shell(strDoIt, 1) 'Clear CutCopyMode Application.CutCopyMode = False AppActivate varRetVal 'Wait some time Application.Wait Now + TimeValue("00:00:03") ' wait 3 seconds DoEvents 'IN ACROBAT : 'SELECT ALL SendKeys "^a" 'COPY SendKeys "^c" 'EXIT (Close & Exit) SendKeys "^q" 'Wait some time Application.Wait Now + TimeValue("00:00:03") ' wait 3 seconds DoEvents 'Paste ActiveSheet.Paste 'Go back to cell A1 Call BackToA1 End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Umesh Dev Sent: Tuesday, January 25, 2011 10:10 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help Required Hi Vikram, I am enclosing a file. It would ask for file each time you run the macros. Use this as a template and the save as daily file. Is it clear? Regards Umesh Dev 9019107882 On Tue, Jan 25, 2011 at 7:51 AM, vikram <vikramahuj...@gmail.com> wrote: Hi Umesh, I need one more help regarding macro enabled sheets. As this DAT sheet is uploaded on daily basis and we need to do this activity daily. Kindly advice how to add this macro to daily files so that we can run this macro created by you. Please provide steps to avoid any errors while adding this coding to daily dat file. Regards, Vikram Ahuja From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Umesh Dev Sent: Sunday, January 23, 2011 7:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help Required Hi Vikram, I hope this would solve your query. Regards Umesh On Sun, Jan 23, 2011 at 11:33 AM, vikram <vikramahuj...@gmail.com> wrote: Hi, I need regarding enclosed excel sheet for Duplicate audit for vendors. As of now we need to identify different type of invoice as per first three numbers of vendors. For ex: Code Category 901 Edible Material 902 Packaging Material 903 Engineering 904 Services 905 MEDIA 906 Capex 907 CFA 908 Edible Material 909 Packaging Material 910 CFA 912 INTERCO 913 Others Steps we are following: 1) On first instance we use Left function to get first three numbers of vendor number i.e for 7 numbers. 2) Then we use v look up to get above details on sheet on DAT sheet. Kindly provide any function or VBA coding to get this avoiding above step. In enclosed sheet Column C contains list of all vendor numbers and on the basis of this we need to get first three numbers on Column I and we need to get categorization on Column j. Regards, Vikram Ahuja 08860553902 -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------- ------ Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
