Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

2015-05-08 Thread Pankaj Sharma
Never lose hope!!!.. The below code we can use for single file. I hope this will help you to make subject easier. - Option Explicit Sub copy_PDF2Excel() Dim AdobeApp As String Dim PDFFile As

$$Excel-Macros$$ Error : Run-Time error '13' Type Mismatch

2015-05-08 Thread Matt
Hi, I'm using VBA to create a pivot table from a sheet with 72k rows of data. When it was at 50-60k, the pivot worked fine but when I use more than that I get a mismatch error at this line below Set PTCache = ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, _ SourceData:=PRange)

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

2015-05-08 Thread Pankaj Sharma
Please find attached file. On Fri, May 8, 2015 at 5:27 PM, Vabz 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

$$Excel-Macros$$ Re: Copy PDF data to Excel macro require

2015-05-08 Thread Vabz
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

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

2015-05-08 Thread Ashish Bhalara
To convert PDF to excel visit the site smallpdf.com On Fri, May 8, 2015 at 3:17 PM, Mandeep Baluja wrote: > I don't think there is any code which can do the same, you need a software > for that. > > > Check this Out. > > Regards, > Mandeep Baluja > Email :-mandeep.bal...@snapdeal.com > mandeep.b

$$Excel-Macros$$ Re: Copy PDF data to Excel macro require

2015-05-08 Thread Mandeep Baluja
I don't think there is any code which can do the same, you need a software for that. Check this Out. Regards, Mandeep Baluja Email :-mandeep.bal...@snapdeal.com mandeep.bal...@gmail.com https://in.linkedin.com/pub/mandeep-baluja/88/7bb/b77 https://www.facebook.com/groups/825221420889809/ On

$$Excel-Macros$$ Re: how to download PDF to specific folder

2015-05-08 Thread Mandeep Baluja
When I tried this code of Ron D burn it working perfectly, first enable your references of outlook. outlook object library follow the steps the method takes three argument Sub Test() 'Arg 1 = Folder name of folder inside your Inbox 'Arg 2 = File extension, "" is every file 'Arg 3 = Save folder

$$Excel-Macros$$ PDF file name with Subject line

2015-05-08 Thread B.N.Chethan Kumar
I am trying to download PDF attachment.. It is working, But need to add Subject along with file name when file is saved in the folder. Kindly advise. -- Chethan -- 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

$$Excel-Macros$$ PDF file name with Subject line

2015-05-08 Thread B.N.Chethan Kumar
-- Chethan -- 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,

$$Excel-Macros$$ how to download PDF to specific folder

2015-05-08 Thread B.N.Chethan Kumar
Respected sir, I am using the following code to download "PDF" from Outlook. But it is giving error message. Kindly let me know how to fix it. Sub Test()'Arg 1 = Folder name of folder inside your Inbox 'Arg 2 = File extension, "" is every file 'Arg 3 = Save folder, "C:\Users\Ron\test" or "" '