HELLO! Great stuff here...
I was wondering if there is a way to set up a process (macro/vba) to have a worksheet to pdf. I created a spreadsheet that bring in stock prices and it charts. What if I wanted many stock symbols to be used to create a chart and then export the chart/worksheet to pdf without entering in each symbol, waiting for chart to build and then click file save to pdf?
The charts take a couple of seconds to refresh when the data is imported (that already is automated when new symbol is entered). This would save a good amount of time as I want 25 stock charts to pdf. Possible????
Much thanks@
Andrew
I was wondering if there is a way to set up a process (macro/vba) to have a worksheet to pdf. I created a spreadsheet that bring in stock prices and it charts. What if I wanted many stock symbols to be used to create a chart and then export the chart/worksheet to pdf without entering in each symbol, waiting for chart to build and then click file save to pdf?
The charts take a couple of seconds to refresh when the data is imported (that already is automated when new symbol is entered). This would save a good amount of time as I want 25 stock charts to pdf. Possible????
Much thanks@
Andrew