View Single Post
 
Old 04-15-2013, 02:11 AM
kbka kbka is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Apr 2013
Posts: 1
kbka is on a distinguished road
Default 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
Reply With Quote