How do I replace DDE?

[uksusu]

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.

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?

Our new Tools that are being deployed are EG4.1, Web Report Studio, OLAP Cube Studio and Information Map Studio.

I have not yet got MS Add-in but that is a possibility if required.

Thanks....

[SASKiwi]

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.

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.

[uksusu]

Thanks for the response. Unfortunately, we don't have the PC File formats licensed.

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?

Will that mean I still need to use VBA to populate the exact cells with the correct data?

[SASKiwi]

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.

If you want to explore the SAS Add-in option, suggest you search SAS support for relevant user papers.

Either way this is probably going to be a fairly manual solution....good luck!

[uksusu]

Thanks for the 'good' news. I'll investigate more on the MS Add-in.