Fetching data from PDF to excel-Alignment issue

I have sucessfully designed a code to extract the datas from pdf to workbook.All the data's are fetching to excel very well with out any issues.
But i have alignment/Rule to place the data's to excel from Pdf..I tried a lot..but am failing when trying.I have attached the
required files for review.Some one please have a look and help me out to complete the code.

1.Pdf files
2.Conversion of current output file
3.Requirement needed in the macro.
4.Required output



Thanks in advance
Lax

Can any one please have a look and help me out

Lax

Can any one please have a look and help me out

Lax

Can some one pls help me as I have done with the main part of the coding.I have to match the alignment alone.pls help me wit this..

Lax

Sorry Friends,

I missed to attache the code so far what i have done.

Please Login or Register  to view this content.

And the second part is :

Please Login or Register  to view this content.

Re attaching the work book also

Thanks,
Lax

Dear masters,
I have done 90% of the code.am struck with the rest.please help me.

Lax

Dear shg,
Thanks ..but I have completed the macro part of fetching details from PDF.my only request is I have to place the details fetching from PDF to be placed in a appropriate cells shown in the required output sheet.I need macro/formula +macro code updates in my macro itself.
Thanks for the help in advance.

Lax

Dear Lewis,

thanks and sorry for the delayed response.

Please find my inline comments for the Questions you raised:

1. The output files are starting at line 17 per your 'required output.xlsx' file. Please let me know if there is anything additional you want. I am discarding everything except the column headers and the actual invoice data.



> Basically, I need the data to be converted from the column headers irrespective of the pdf Invoice copy Type 1. That mean's, post conversion of pdf file the data converted should include all the column headers along with the respective values. Also, if you could extend the range for each page post conversion. Since this would include all the converted values and also would not overlap on the other page data converted values.


2. All data is formatted as text for ease in 'PrettyPrint' (i.e. there is a 'single quote' [aka apostrophe ' ], inserted in front of each field. Please let me know if you need any cells formatted specifically as numbers. This will be needed only if you are going to do numerical calculations on those cells.


> Kindly keep the formatting for the column H ( Price ) and column L (Amount) as numbers for calculation purpose, rest all can be accepted as Text format.


3. The Output .xlsx files I am creating are in the same folder as the input files.


> The path is OK.


4. The Output .xlsx files are named with 'Output' appended to the 'Base File Name'. For example if the raw file is xyz.xlsx, then the output file will be xyzOutput.xlsx.

>File name is OK.

Just to confirm, if you are appending my macro i.e (basic conversion of pdf to excel version) in the new requirement (your's current macro).



5. The Sheet Name in the 'Output File' is 'Table 1'. All other Sheets in the output file (if any) will be deleted.

>I believe as the Output File generated would be invoice specific and thus no other Tab sheets will be generated.



Please help me to complete my rest part.Waiting for your next reply..

Thanks,
Lax

Dear Lewis,

as discussed i have attached 3 invoice files.PFA..Thanks in advance

See the attached file 'ExcelForumConvertInvoices.xlsm'. I've included renamed .xlsx file and renamed .pdf files in the zip file also, for ease of testing. Many of the .xlsx files created by Adobe Acrobat, especially the ones with Optical Character Recognition (OCR), were not well behaved. Misbehavior included:
a. Lines out of order
b. Lines concatenated together
c. Missing data
d. OCR errors which include:
(1) Changing a 5 to an S
(2) Elminating the character '1' (e.g. '2014' becomes '2 14')

I corrected the misbehavior the best I could, but I am afraid that you will have to manually examine each file to make sure that the data is correct.
-------------------------------

There is a different macro that processes each File Type or SubType:
1 = 'Sobeys' Invoices
2A = 'BUY LOW' Invoices (Acrobat Optical Character Recognition)
2B = Returns to 'GENERAL MILLS CANADA' (Acrobat Optical Character Recognition)
3 = 'CO-OP ATLANTIC' Request For Adjustment

Each Type/SubType is in in it's own module. Module 0 (mInvoiceType0 )contains code to identify Type/SubType and also contains Utility Routines.

---------------------

I made a few small changes to your original code (module mExportAllPDFs) to allow my code to be executed after all the .pdf files are processed. The changes I made are highlighted in red:

Please Login or Register  to view this content.

To test what I've done, I suggest you put all the files alone in their own subfolder and test using my Excel file. If you are satisfied with results, then you can copy the macros over to your file. Since I am using Excel 2003, there may be features in your file that are not present in mine.

Lewis