So we have a process that currently looks like this: Excel file #1 gets dropped in a file folder on our Windows Shared S: Drive network. User copies data from Excel File #1 and pastes it into the "INPUT" sheet in Excel File #2 (macro-enabled). The user runs the macro which calculates various helper columns, then interpolates the data to arrive at a single calculated column. The user copies the calculated outputted column from file #2 and pastes the calculated column into Excel file #3, which runs a final macro that creates a .CSV file and drops it into a specific file location for our SAP ERP system to ingest. This occurs every day at end of day. My current thoughts are either to re-do the entire process in SAS (longer to develop, but ability to add enhancements in the future to the process if needed) OR alternatively just use SAS to trigger the VBA macros so that we can streamline and remove the manual work of copying and pasting data to various sheets (just get SAS to copy and paste the data to various spreadsheet files and then trigger the macro in the workbook).   What are your guys thoughts? ... View more