About C20325A

ballardw · ‎10-25-2017

@C20325A wrote: Update: this is now solved! I used the %sysexec command to open the specific Excel i was using, and then I have to Enable Editing on the document. There are several other programs out there that will interfere with DDE connections to Excel. If the only purpose is to read the file there are many other ways that are more reliable.

Reeza · ‎10-11-2017

Change your process - whatever it is to process all your columns at once rather than two at a time. Otherwise you're reading your data too many times. Without more details that's the best we can offer. You can review the Don't be Loopy paper by David Cassell for more details on why you shouldn't use macros.

Online Status	Offline
Date Last Visited	‎11-02-2017 10:35 AM

Re: Error using DDE to download Excel spreadshet

Error using DDE to download Excel spreadshet

Proc SQL vs Data step advice

Re: Error using DDE to download Excel spreadshet

Re: Error using DDE to download Excel spreadshet

Re: Error using DDE to download Excel spreadshet

Re: Error using DDE to download Excel spreadshet

Re: Proc SQL vs Data step advice