Copy pdf to excel with formatting

in Book by

I have copy pdf to excel with formatting bits of code. 35a7 7 0 1 1 1. 9 2 2 2h16a2 2 0 0 0 2-2v-4. 44A2 2 0 0 0 15.

68A1 1 0 0 1 5. 12a1 1 0 0 1 . M9 1a8 8 0 1 0 0 16A8 8 0 0 0 9 1zm. 69a4 4 0 0 0-. 29 0 0 1 1. 34 0 0 0 .

8 0 0 0 2. 07A8 8 0 0 0 8. 8 0 0 1 0-3. 83a8 8 0 0 0 0 7. 3A8 8 0 0 0 1.

77 0 0 1 4. Now this second method is much faster, avoiding copying to clipboard and pasting again. However it does not copy across the formatting as the first method does. The Second version is almost instant to copy 500 lines, while the first method adds about 5 seconds to the time.

And the final version could be upwards of 5000 cells. I can do further sorting and operations on them before I “paste” them back on to the worksheet. RTF strings in VBA or is that only possible in vb. Use comments to ask for more information or suggest improvements. Avoid answering questions in comments. Although I could calculate the range the cells I am copying from are not in a range. The code searches multiply sheets for a given criteria, if it finds a row that meets the criteria it copies a specific cell from that row to the output sheet.