thanks for the comments interesting discussion around excel, i know a number of people in my team think that providing excel just with the report already created is an advantage because then it is less likely to not work or something to break and yes just provides the data that someone might want for a specific presentation etc. However others in the team think that too much of the process can be hidden in SAS or similar and its harder for someone to step through the process and error check or whatever. With my specific example I have one spreadsheet where someone makes updates/calculations/decisions about targets, there is a lot of data and calculations in here and I just really need the output of this, I then copy it into another report where weekly data is measured against those targets. This one is pretty simple I think if its possible to just take information from a cell range in a specific sheet within an excel file (i hope) and then push it back out again?! The other one regarding an engine is to do with forecasting so making calculations based on basically a modelpoint etc which the macro cycles through and then copy and pastes the results to another sheet, its easy to step through the macro if something isn't working correctly or something needs to be changed, so that was the concern about having it in SAS, however I am open to advice/suggestions as I am following what has generally be done in our team and that doesnt necessarily mean its the best way to do it!! It would be great however if I could run the macro from SAS (while also creating the datasets i need) rather than having to open the excel file and run the marco separately.
... View more