https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-replace-DDE/m-p/34809#M4406 Apart from the SAS Add-in the only other option I can think of is to get SAS to export the data out as a CSV (comma-delimited) file and then use Excel's data import functionality to read the data into a blank worksheet. From this worksheet you can use VLOOKUP Excel formulas to pick up the correct data and put it in the correct cell in your existing reports.<BR /> <BR /> If you want to explore the SAS Add-in option, suggest you search SAS support for relevant user papers.<BR /> <BR /> Either way this is probably going to be a fairly manual solution....good luck! Thu, 18 Nov 2010 20:45:12 GMT SASKiwi 2010-11-18T20:45:12Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-replace-DDE/m-p/34806#M4403 I hope someone can help. I have a number of regulatory reports that are Excel templates that require completing each day/month. At present I use BaseSAS and DDE the output to the relevant cells that need populating.<BR /> <BR /> We are migrating onto EG and I need to find a workaround from DDE, as I cannot change the Report style or type. What options are open to me?<BR /> <BR /> Our new Tools that are being deployed are EG4.1, Web Report Studio, OLAP Cube Studio and Information Map Studio.<BR /> <BR /> I have not yet got MS Add-in but that is a possibility if required.<BR /> <BR /> Thanks.... Wed, 17 Nov 2010 17:20:47 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-replace-DDE/m-p/34806#M4403 uksusu 2010-11-17T17:20:47Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-replace-DDE/m-p/34807#M4404 Do you have SAS/ACCESS to PC File Formats licensed on your EG Server? Without that your options would be probably limited to MS Excel Add-in. <BR /> <BR /> ODS can export to Excel but it builds XML spreadsheets for scratch each time, so unless you are prepared to change your layout to suit ODS this is probably not an option. Wed, 17 Nov 2010 21:29:30 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-replace-DDE/m-p/34807#M4404 SASKiwi 2010-11-17T21:29:30Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-replace-DDE/m-p/34808#M4405 Thanks for the response. Unfortunately, we don't have the PC File formats licensed. <BR /> <BR /> Are you able to point me in any direction for training material etc. The Excel format cannot change at all, due to it's external regulatory audience, so does that mean that MS Excel add-in is my only option?<BR /> <BR /> Will that mean I still need to use VBA to populate the exact cells with the correct data? Thu, 18 Nov 2010 10:15:46 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-replace-DDE/m-p/34808#M4405 uksusu 2010-11-18T10:15:46Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-replace-DDE/m-p/34809#M4406 Apart from the SAS Add-in the only other option I can think of is to get SAS to export the data out as a CSV (comma-delimited) file and then use Excel's data import functionality to read the data into a blank worksheet. From this worksheet you can use VLOOKUP Excel formulas to pick up the correct data and put it in the correct cell in your existing reports.<BR /> <BR /> If you want to explore the SAS Add-in option, suggest you search SAS support for relevant user papers.<BR /> <BR /> Either way this is probably going to be a fairly manual solution....good luck! Thu, 18 Nov 2010 20:45:12 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-replace-DDE/m-p/34809#M4406 SASKiwi 2010-11-18T20:45:12Z https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-replace-DDE/m-p/34810#M4407 Thanks for the 'good' news. I'll investigate more on the MS Add-in. Fri, 19 Nov 2010 09:32:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/How-do-I-replace-DDE/m-p/34810#M4407 uksusu 2010-11-19T09:32:45Z