Improve quality of exported chart

I was working with automatically exporting the contents of a textbox to an image file and found this post which I was able to modify slightly for my purposes.

http://www.excelforum.com/excel-prog...ml#post1982405

Is it possible to improve the quality of the output image. I need to print out the resulting image and the quality of the image this method creates is too poor for my purposes.

Thank you for any help

Hello bhofsetz,

I clicked on the link and the system can't find it. Recheck that it is valid link.

Sincerely,
Leith Ross

Sorry,

Here's the correct link.

http://www.excelforum.com/excel-prog...ml#post1982405

Thanks for taking a look.

I am trying to output the contents of a textbox to an image file.
*.bmp, *.jpg, *.gif
The exact image file type doesn't matter as long as I can use this as a header image for an Excel 2007 file.

TBtoImage.xls

TBtoImage10pt.bmp

The reason I am using this approach is that the information I need to put in the header exceeds the 256 character limit imposed by Excel. I have investigated other options for getting the information into the header, i.e. using the first several rows as a "header" on the sheet, etc. But overall this will be the most desirable.

What I have found is that if I export the textbox to an image file with the font size I want in my header. The use the resulting image in the header the printout is extreemly poor quality (grainy, dark shadows, etc.).
One intermediate solution I have come up with is to first increase the font size in the text box five times lager than I want in the print out. Export the textbox to an image. Select the image for my header and adjust the image size to 20% of original.
This seems to work reasonably well but is a bit cumbersome and I was looking for a more straightforward solultion.

Thanks again for any help

Thanks for the link and file Andy. That looks like a more straightforward way to do what I'm after. I did find that I still needed to increase the font size of the textbox text before exporting it and then showing at 10% of original size to get better quality in the printout. However this is all accomplished easily by slightly modifying the code in the workbook you attached. I have attached my slight modification of that code and file here. I also found that if you have different font sizes in the textbox it will only work for the font size of the first text in the box. However it will maintain other text formatting such as font style or bold.

Thanks again for the help.

TBtoImage2.xls