Hi Vikram, Its working in my sys. if its not working on your sys then let me know where the file is saved and also where your acro-reader is saved.
Regards Umesh Dev On Sat, Jan 29, 2011 at 12:50 PM, vikram <vikramahuj...@gmail.com> wrote: > Hi, > > > > Please help regarding below query as I need this on urgent basis to > complete the report. > > > > > > > > Regards, > > > > Vikram Ahuja > > > > *From:* vikram [mailto:vikramahuj...@gmail.com] > *Sent:* Thursday, January 27, 2011 10:49 PM > > *To:* 'excel-macros@googlegroups.com' > *Subject:* $$Excel-Macros$$ Help Required_pdf file conversion > > > > Hi Umesh, > > > > Please find enclosed macro enabled sheet for converting pdf data to excel > data but I am still getting error message as mentioned below. > > > > I have done below steps for running this macro: > > > > 1) Saved Pdf data on “D:\VIKRAM FILES\process data\asl” and changed > this path on macro coding as well. > > 2) Saved macro coding and run this macro for execution but still > getting error message as “error message 400”. > > > > Kindly help in this regard to get this data converted in excel format. For > your reference please find enclosed pdf data which needs to be converted. > > > > 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 > -- ---------------------------------------------------------------------------------- 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