Exciting, I have for some time been thinking about how to create a quote for a customer from existing Excel data into e.g. Word. Here is an example, right?
Hi Henrik, exactly yes! This technique works well if you have a template document in Word which contains bookmarks. We have a video which covers this technique and you can see the relevant section starting at 51:48 ua-cam.com/video/z7gUwuOxZAY/v-deo.html I hope it helps!
Great explanation, quick question; Since excel or word doesn't support OCR. But in VBa, you can add a complement for Onenote. Is it possible to extract picture to text by using Vba directly from Word/Excel then past the 'text' to word/excel file? Instead of going through OneNote to past then picture to text, etc.
Hi! That's an interesting question! I've not attempted to do this but several links appear to suggest that it is possible www.excelforum.com/excel-programming-vba-macros/1193886-possible-for-vba-to-to-ocr-embedded-picture-objects-and-copy-text-values-to-cells.html#post4703560 social.msdn.microsoft.com/Forums/office/en-US/9569d75c-eb85-4612-98b9-04a45a2b9e7b/onenote-is-not-giving-ocrtext-for-vba-inserted-image-in-onenote-2010how-to-force-onenote-to-do?forum=officegeneral I hope it points you in the right direction!
I have a number of charts on a single worksheet in Excel. I want to export a single picture of all of them in the png format to a folder. I have used the .CopyPicture method but it seems to fail sometimes. What is the best way to export a picture of charts or a specific range in Excel directly to a folder i.e. not to MicrosoftWord?
Hi there! I can't say that this is something I've ever needed to do but it appears that there's a range of creative solutions out there. The "simplest" approach seems to be, as you said in your question, using the CopyPicture method to copy the range of cells which the charts cover and then pasting this into an empty Chart object so that you can then use the Export method of the Chart to save the picture (I'm guessing that this is what you've already tried). One post addressed the unreliability of this technique and suggested adding a DoEvents statement between the CopyPicture method and the Paste method. I'm not sure if that helps. You could also try this fantastically complicated solution involving many Windows API function declarations! stackoverflow.com/questions/43904385/using-excel-vba-macro-to-capture-save-screenshot-of-specific-area-in-same-file/55354715#55354715
@@WiseOwlTutorials Thanks for the reply Andrew! I will definitely give that a go and yes that is what I’ve been trying to do i.e. paste into an empty Chart object and then use Export method.
@@WiseOwlTutorials Hi Andrew. It’s been about a week now since I applied your suggested fix to my question - I added DoEvents between CopyPicture and Paste. It worked! Everything has been chugging along very stable this week. Thanks again for your reply and solution.
@@benjild1 That's great to hear! I can't take the credit for it but I'm pleased to hear that it's working for you and thanks for taking the time to come back and let us know!
Hi sir, I have excel sheet and word template (separately). I can use word template to create another word with excel data filled in it by VBA code. I embedded the word template in to excel sheet. After that I trying to use embedded word template to create new doc with excel data in it ( just like when they are separate) but unable to do. Can you help me..
Hi Nagaraju, that's an interesting idea! It's not how Office is designed to work so there's no native support for it but it seems that it is possible. Here's one example stackoverflow.com/questions/54419143/edit-word-document-embedded-in-a-workbook-and-save-as-copy I hope it helps!
Thanks for the suggestions Asad! I'll put the PDF and SendKeys on my list. I don't think that PowerShell will happen in the near future - it needs an entire series to do it justice!
Thanks Andrew. Happy Easter!
My pleasure Kevin, and a Happy Easter to you and yours too!
Beautifully explained as always. Thank you sir.
You're very welcome Rohith, thanks as always for your support!
Thank u so much for ur best, fun, and amazing videos
You're very welcome, thanks for watching!
You answered my unasked question as well. Thank you.
Excellent, happy to hear that it helped!
Thank you Andrew excellent topic.
Thanks Rafael, glad you enjoyed it!
Great Sir I really enjoy this training session
Thanks Pankaj, glad you liked it!
Thank you very much for your awesome videos.
You're very welcome Yasser! Thank you as always for your support!
Exciting, I have for some time been thinking about how to create a quote for a customer from existing Excel data into e.g. Word.
Here is an example, right?
Hi Henrik, exactly yes! This technique works well if you have a template document in Word which contains bookmarks. We have a video which covers this technique and you can see the relevant section starting at 51:48 ua-cam.com/video/z7gUwuOxZAY/v-deo.html
I hope it helps!
Excellent
Thank you Hassan!
This is awesome!!!!! Thank you for the video.😁😁
You're very welcome Kunal, glad you like it!
Great explanation, quick question;
Since excel or word doesn't support OCR. But in VBa, you can add a complement for Onenote.
Is it possible to extract picture to text by using Vba directly from Word/Excel then past the 'text' to word/excel file?
Instead of going through OneNote to past then picture to text, etc.
Hi! That's an interesting question! I've not attempted to do this but several links appear to suggest that it is possible
www.excelforum.com/excel-programming-vba-macros/1193886-possible-for-vba-to-to-ocr-embedded-picture-objects-and-copy-text-values-to-cells.html#post4703560
social.msdn.microsoft.com/Forums/office/en-US/9569d75c-eb85-4612-98b9-04a45a2b9e7b/onenote-is-not-giving-ocrtext-for-vba-inserted-image-in-onenote-2010how-to-force-onenote-to-do?forum=officegeneral
I hope it points you in the right direction!
@@WiseOwlTutorials Hi,
Thanks for your reply, appreciate it.
I will take a look :)
Hopefully that will help for my current problematic.
I want one first row of excel as heading all word documents
How to do that ?
Is mentioned technique the same for PowerPoint?
Hi! It's not quite the same, no. You might find this video helpful for PowerPoint ua-cam.com/video/e1kUWZqCkRw/v-deo.html
I have a number of charts on a single worksheet in Excel. I want to export a single picture of all of them in the png format to a folder. I have used the .CopyPicture method but it seems to fail sometimes. What is the best way to export a picture of charts or a specific range in Excel directly to a folder i.e. not to MicrosoftWord?
Hi there! I can't say that this is something I've ever needed to do but it appears that there's a range of creative solutions out there. The "simplest" approach seems to be, as you said in your question, using the CopyPicture method to copy the range of cells which the charts cover and then pasting this into an empty Chart object so that you can then use the Export method of the Chart to save the picture (I'm guessing that this is what you've already tried). One post addressed the unreliability of this technique and suggested adding a DoEvents statement between the CopyPicture method and the Paste method.
I'm not sure if that helps.
You could also try this fantastically complicated solution involving many Windows API function declarations! stackoverflow.com/questions/43904385/using-excel-vba-macro-to-capture-save-screenshot-of-specific-area-in-same-file/55354715#55354715
@@WiseOwlTutorials Thanks for the reply Andrew! I will definitely give that a go and yes that is what I’ve been trying to do i.e. paste into an empty Chart object and then use Export method.
@@benjild1 No worries, I hope it works!
@@WiseOwlTutorials Hi Andrew. It’s been about a week now since I applied your suggested fix to my question - I added DoEvents between CopyPicture and Paste. It worked! Everything has been chugging along very stable this week. Thanks again for your reply and solution.
@@benjild1 That's great to hear! I can't take the credit for it but I'm pleased to hear that it's working for you and thanks for taking the time to come back and let us know!
Hi sir,
I have excel sheet and word template (separately). I can use word template to create another word with excel data filled in it by VBA code. I embedded the word template in to excel sheet. After that I trying to use embedded word template to create new doc with excel data in it ( just like when they are separate) but unable to do. Can you help me..
Hi Nagaraju, that's an interesting idea! It's not how Office is designed to work so there's no native support for it but it seems that it is possible. Here's one example stackoverflow.com/questions/54419143/edit-word-document-embedded-in-a-workbook-and-save-as-copy
I hope it helps!
Thank you Andrew,
Plz make videos on "scrapping data from PDF" and how to use PowerShell command and Send keys in VBA.
Thank you..
Thanks for the suggestions Asad! I'll put the PDF and SendKeys on my list. I don't think that PowerShell will happen in the near future - it needs an entire series to do it justice!
As always, your videos are top of the line. You always explain everything so clearly.
Hi Eva!
Yes, you can copy pictures, you just need to know how to reference them
Sub CopyPicToWord()
Dim wd As Word.Application
Dim ImgToCopy As Shape
Set wd = New Word.Application
wd.Visible = True
wd.Documents.Add
Set ImgToCopy = Sheet1.Shapes("My Picture")
ImgToCopy.Copy
wd.Selection.Paste
End Sub
You might find the videos on working with shapes useful ua-cam.com/video/GK7ifXM3alI/v-deo.html
I hope it helps!
@@WiseOwlTutorials Thank you so much for the super quick answer. It works!