Hello,
Total noob to VBA and Excel reporting.
We have a set of Excel Reports generated through a combination of Java & VB Processes. The process generates reports based on an Excel Template file. Most of the formatting is controlled in the Excel file. Every week, based on the template file, a new Excel report file is generated.
One particular chart is giving me grief. For some reason, the labels on the chart if it is 0.00, is being overwritten to Calibri Size 10. I changed it in the template file, also manually overwrote it on the VBA code, but in the final report, it resets the font size to Calibri 10.
So, I'm thinking I could write a small VB Script to open the file and update the chart label based on the value. I can run the script from a bat file after the report is generated.
Any thoughts on if this is a good approach? How do I go about it? Where do I even begin?
Any input on this is greatly appreciated.
Thanks & Regards,
V
Total noob to VBA and Excel reporting.
We have a set of Excel Reports generated through a combination of Java & VB Processes. The process generates reports based on an Excel Template file. Most of the formatting is controlled in the Excel file. Every week, based on the template file, a new Excel report file is generated.
One particular chart is giving me grief. For some reason, the labels on the chart if it is 0.00, is being overwritten to Calibri Size 10. I changed it in the template file, also manually overwrote it on the VBA code, but in the final report, it resets the font size to Calibri 10.
So, I'm thinking I could write a small VB Script to open the file and update the chart label based on the value. I can run the script from a bat file after the report is generated.
Any thoughts on if this is a good approach? How do I go about it? Where do I even begin?
Any input on this is greatly appreciated.
Thanks & Regards,
V
