Actually we are generating lot of Excel files using DDE. Unfortunately, we are launching the process at the SAS server and often it terminates by error (typically: Excel opens some interactive window and is waiting for a response - and that is a real problem by automatic processing).
Our intention is try to avoid the DDE usage and replace it by some technique that does not need to open Excel. (But we need to write into an EXISTING Excel spreadsheet, we also use Excel graphs... such solutions like ODS HTML does not serve us...
I have found that theoretically one possibility is to use LIBNAME statement with Excel "Named ranges", but I do not achieve to write the data without varnames. Also I do not know if there is some limitation for the number of Named ranges in one Excel File.
Does anyone know how to solve this?
Is there any way how to omit the varnames when using LIBNAME (engine:xls) for output?
Or better: Is there any other elegant solution?
As for your question about VARNAMES, I believe that when the LIBNAME engine is appending data, it can write without VARNAMES -- but I think you may need a named range for that. This would be a question for Tech Support...since it's not entirely clear to me what you mean by omitting the varnames.