I am in the process of building a couple of product generating spreadsheets, for personal and corporate use. I'm currently working on a XY Scatter chart generator that looks at sales distribution or different product, across different areas. The generator itself is fairly simple, and is operational, however there is one thing I would like to vba/macro, to make it easier for a couple of my coworkers, who have difficulty working with the less common aspects of EXCEL.
What I would like to be able to do, is two things...
1. Use VBA to change the image that is loaded into the PLOT AREA of the chart, not the CHART OBJECT BACKGROUND
The reason for this, is that there are series of different geographic areas that these products will cover, and each requires a different background image, most of which are maps, or production and distribution networks, so I would like to be able to click a button, have the select file window open, and when I click OK, have the PLOT AREA image change to the selected image... I have attempted to record a macro of the process, but I cannot get it to work
2. Use VBA to open a "Open File" dialog box, to select a file path to save the output file to.
The worksheet exports the chart, as a PNG, to the filepath that the user designates, however, the user must go into My Computer, and copy the filepath manually, and I would like for this to be internalized to the spreadsheet, to make the workflow smoother.)
What I would like to be able to do, is two things...
1. Use VBA to change the image that is loaded into the PLOT AREA of the chart, not the CHART OBJECT BACKGROUND
The reason for this, is that there are series of different geographic areas that these products will cover, and each requires a different background image, most of which are maps, or production and distribution networks, so I would like to be able to click a button, have the select file window open, and when I click OK, have the PLOT AREA image change to the selected image... I have attempted to record a macro of the process, but I cannot get it to work
2. Use VBA to open a "Open File" dialog box, to select a file path to save the output file to.
The worksheet exports the chart, as a PNG, to the filepath that the user designates, however, the user must go into My Computer, and copy the filepath manually, and I would like for this to be internalized to the spreadsheet, to make the workflow smoother.)
