Forum Discussion
Macro to import data from picture
Hi, I have been asked to create a macro to insert data from a picture. Right now, I copy the picture from an email, go to excel, go to data tab, and insert picture from clipboard. Is it possible to create a macro to import the data from the picture once I have copied the picture to the clipboard? I tried to record a macro but it didn't work. Thank you!
btroland
3 Replies
- Just found another thread... It sounds like it is only available on MAC, IOS and Android.
- According to MicroSoft Support this is supposed to be possible. See the link below for directions. I have tried, but, the Data > From Picture button does not seem to exist even though I'm on Windows11.
https://support.microsoft.com/en-us/office/insert-data-from-picture-3c1bb58d-2c59-4bc0-b04a-a671a6868fd7#:~:text=Scenarios%20to%20try-,Import%20data%20from%20a%20sample%20image%20file%20Right%2Dclick%20the,convert%20the%20picture%20to%20data. As of this writing you've had 56 views and zero answers. I strongly suspect it is because it's not really clear what you're trying to do.
What do you mean by "import data from the picture"? What kind of picture is it? A picture of words, numbers, combination? Is it a picture attached to an email, or are you taking a picture OF the email?
Those are starters for questions that, if answered, might get us closer to knowing what you're working with. If you could post a copy of the spreadsheet on OneDrive or GoogleDrive, with a link pasted here granting edit access, that would help even further. At a bare minimum, post a copy of the "picture" here in your next reply.
