Importing multiple SP files into one excel worksheet via macro's

[michaeldan]

I have multiple (8) sp files containing two columns of interest each. i'm hoping to import these two columns from each sp file into one excel workbook for plotting into an xy line graph (each sp file will be one series in my graph).

I have lot's of graphs to make for an approaching deadline so a degree of automation would be most welcome! i'm a complete newbie to VBA and macro's in Excel