Hi
I have a spreadsheet (Excel) with several data sheets and 6 report sheets with charts on them. (The data for the charts is on the data sheets). I want to be able to send out the report sheets without the data sheets, and without a message box coming up when people open it to ask them whether to update the links or not.
I can copy each report sheet and paste as a picture into a word document which is pretty neat, however what I really want to do is to automate this process in a macro. So, how do I load Word, open a new document and then select each report sheet in excel and paste into word in a macro ?
Ot has anyone any other ideas ??
Grateful for any help !!
Jane
I have a spreadsheet (Excel) with several data sheets and 6 report sheets with charts on them. (The data for the charts is on the data sheets). I want to be able to send out the report sheets without the data sheets, and without a message box coming up when people open it to ask them whether to update the links or not.
I can copy each report sheet and paste as a picture into a word document which is pretty neat, however what I really want to do is to automate this process in a macro. So, how do I load Word, open a new document and then select each report sheet in excel and paste into word in a macro ?
Ot has anyone any other ideas ??
Grateful for any help !!
Jane