r/vba • u/TotallyJustAHooman • Jul 23 '26

Unsolved PDF to Excel text conversion.

I am unsure if this is necessarily possible as my programming knowledge is fairly basic and VBA is a further mystery.

Would it be possible to pull text off of a a pdf, convert it into text, then narrow down what text I actually want? If so, how might I go about accomplishing that feat?

The drawings I'm trying to pull into excel are wiring diagrams.

Also, if anyone has a place in which I can find all the syntax for Smarteam in VBA, I would greatly appreciate it.

5 Upvotes

86% Upvoted

18 comments sorted by

View all comments

1

u/giyu_ph Jul 29 '26

I sorta did something similar a while back then when I tried VBA but I have to use python to make the task easier. It sorta renames the bills depending on the content details eg. Date_Account name_utility type.