Convert PDF header to Excel headers

**taichi56** · 03-31-2011, 04:57 PM

I received the following code from this forum:

Please Login or Register  to view this content.

This code has helped me tremendously. But now I need it for another PDF sheet that is formatted a little different and I cannot seem to get it to work. I have attached a sample of the info with the VBA coding. I have a workbook that has 2500 students formatted this way. I need to be able to put it in a format that I can upload to a database. Thank you.

**mojo249** · 03-31-2011, 06:31 PM

If the following are always the case then try the code below:

1) Cell A1 always contains the same information (ID #, Student Name and Grade in that order)
2) The exam results always start in row 4 (there can be any number of them but they must start in row 4).

If the above conditions vary then you'll need to specify the possible variations so they can be programmed for.

Please Login or Register  to view this content.

I notice you don't extract the exam type (maths, science etc). Is that not important?

Hope that helps.

Dion

**taichi56** · 04-01-2011, 10:56 AM

Ok, that did what I needed, almost. It gave me three more studentID, Name and grade that I did not need. Also, yes the exam results are always in row 4. Yes, the exam information needs to be extracted. I ran this on my main page and it only took the first student. I have over 2500 student in this workbook. Each one of the students is formatted the same way the first one is. Thank you for your help.

**taichi56** · 04-04-2011, 04:27 PM

Well I have been messing with the coding and this is what I have so far:

Please Login or Register  to view this content.

But it is giving me the following:

Please Login or Register  to view this content.

As you can see it gives me three extra StudentID and Name for the same student. Then it goes to the next set of data and gives it to me exactly how it looks in the PDF. Not sure what I am doing wrong.