Yes, of course you can write a macro to export the data to Excel - but again - have you looked at the visual reports? It is also not clear from your post what data you wish to plot in an S-curve. If you are looking for the standard Earned Value data - it's already made for you in visual reports.