johnny51981
Active Member
- Joined
- Jun 8, 2015
- Messages
- 404
Upfront Admission: My VBA skills are limited to one lines of code and plagiarism. So I will be zero percent offended if spoken to like a Excel baby.
That said. I am working on a Power Query file that is reading a folder location of PDF files. From those files, I scrape out permanent information associated to the work that we are being asked to do from our customer. Problem is, while they are visibly the same format of PDF, they are so very not due the just not clean way of the developers of the tool created it. Example, the job address could be on one line, and it picks up cleanly...but if there is a return carriage, then I have to figure out how to get the whole lot of it. Not the part I'm asking about right now.
I am working in a phased progression that I will continue honing in on the needed data, but would like to juggle between a DEV version and a PROD version and would like to move my updates in Custom Functions and Queries from the DEV to the PROD by way of VBA.
Is this possible? If so....can you tell me, slowly and in crayon, how to achieve it?
That said. I am working on a Power Query file that is reading a folder location of PDF files. From those files, I scrape out permanent information associated to the work that we are being asked to do from our customer. Problem is, while they are visibly the same format of PDF, they are so very not due the just not clean way of the developers of the tool created it. Example, the job address could be on one line, and it picks up cleanly...but if there is a return carriage, then I have to figure out how to get the whole lot of it. Not the part I'm asking about right now.
I am working in a phased progression that I will continue honing in on the needed data, but would like to juggle between a DEV version and a PROD version and would like to move my updates in Custom Functions and Queries from the DEV to the PROD by way of VBA.
Is this possible? If so....can you tell me, slowly and in crayon, how to achieve it?
