So I have (some sort of standard) code to generate a Html emailbody.
Problem is I have data and on this data there is a chart.
Now when I copy and paste the range of these 2 sections it only gives me the data but not the chart (leaves that space blank).
Can someone explain how I can adjust this code so it also will paste the chart?
Thanks!
This is the code :
Please Login or Register to view this content.
Copy the picture as an image and save it locally, semi-unique file name, add the date on or something, c:\temp\tempchart06082014 and then add it in HTML <img src='c:\temp\tempchart06082014.jpg" /> then delete the file.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Hmm thanks nathansav, but that is really something I rather not do.
Was expecting there must be a way that excel can recognize that the copied range contains a chart and then includes it in the copy.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks