sarasaurus
New Member
- Joined
- Jul 29, 2011
- Messages
- 1
I'm looking for a script that will make Excel do the follow series of steps:
go through each tab in the workbook
IF there's a graph on the tab, I want Excel to copy it and paste it into a word document. I would like Excel to post all the graphs into the same word document, one below the other.
If there's no graph in that tab, I want excel to do nothing and continue on.
My workbook will have tabs that are just graphs, and tabs that are full of data. I only need it to C&P the graphs I have into a new word document.
Thanks in advance for all the help!
go through each tab in the workbook
IF there's a graph on the tab, I want Excel to copy it and paste it into a word document. I would like Excel to post all the graphs into the same word document, one below the other.
If there's no graph in that tab, I want excel to do nothing and continue on.
My workbook will have tabs that are just graphs, and tabs that are full of data. I only need it to C&P the graphs I have into a new word document.
Thanks in advance for all the help!