Macro to import all diagrams from an excel file
Hi,
I have a recurring assignment where I need to import all the diagrams from an excel file to a word file.
I have earlier used the linked objects feature without any problems. However, in this case the excel file is generated automatically by some software with a new filename etc.. I would like to be able to have a macro in a word template that imports all diagrams from an excel file that is specified in with a popup as the Macro is run or something like that.
The're are always the same number of diagrams.
Have anybody used such a macro or anything in same ballpark?
Any help and/or suggestions is much appreciated!
Regards,
Kristian
|