Hi Peeps, We are using a SAS code to create RM Scorecards by using DDEs and VBA code inbuilt. By using this SAS programme/ by the end of process, it will generate RM level scorecards. It will create a excel file, insert multiple sheets, Rename them. Removes unwanted rows in between and does grouping. To fulfil this process, SAS system will open each RM Scorecard multiple times. Each time it asks for permission to access the Excel file and while saving the file it will show the warning message how actually an excel file show while replacing the file with the same name. the possess use to run with out any manual inversion in windows 7. But after getting upgraded for Win10 we are forcing to click on Ok(while opening the file) and Yes (while saving the file). Please drop me a note if you have any solution.
... View more