Mar 18 2023 08:15 AM
Hello All,
Anyone has any example VBA code to Get and Transform Data from pictures?
I tried to record opening a .JPG image, a receipt, and extract the data into a range but nothing of substance was recorded!!!
The data was imported really nicely except it had some issues with the % signs. The sales tax rate was interpreted as 8 0 / 0 instead of 8%. But that is the least of my worries. I am pretty impressed that it knew where the data is, and how many columns it needed, and even the font was imported properly, with boldness where it is bold in the image.
I know this is a new feature and that is why I am asking.
Thanks in advance for any clues.
Mar 19 2023 07:22 AM
Here are some links to VBA code examples that extract data from pictures:
I hope this helps!
...if this doesn't help, please just ignore it :).
Mar 19 2023 12:20 PM
Mar 19 2023 11:23 PM
Since my understanding of the language is not quite sufficient to understand the question more precisely, I have sent you these links, which may be of some help to you.
However, I would ask and recommend that you send a more detailed description of your project (step by step), with photos if possible, or a file with an example. At the same time, with your permission, I encourage you to provide more information about your digital environment. Digital environment is: Excel version, operating system, storage medium, Excel file type, etc..
This could lead to a better proposed solution.
Thank you for your patience and understanding