View Full Version : Opening files with a macro+charts

11-30-2012, 01:37 AM
Hi everyone!

I have the following situation at hand: I have an excel file with lots and lots of file paths leading to certain .log files. I need a macro or code, so that when I select a cell with a filepath and run the macro, the file will be opened in excel and three separate charts of type xlLine for columns E, M and P be created, so that all three charts are visible(fit) on the screen. :doh:

Any help will be greatly appreciated! :help