Yeah, I hadn't even experienced the DDE side of it, but our London Office called with the same problem.
When they used the generic start Excel, the new screen in excel 2016 opening a file caused it to lock.
When they specifiec a specifc spreadsheet they had better luck, but still experience some blips and bumps.
I'll know more after they've played with it more.
... View more
It appears that our support team neglected to install the Microsoft Access Run-Time 2016 components. This resolves the issue.
Thank you all.
... View more
Our office is upgrading to Office 2016.
The first user they upgraded started having problem using a libname db xlsx statement.
I get an
error xlsx engine can not be found.
v 9.4 1m3 and v 9.3 Windows 7 32 and 64 bit.
If I install sas on a machine that has already been updated, it works fine.
I think it's has to do with the aceexcl.dll file but not familiar enough.
has anyone else ran into this?
... View more
Thanks Patrick, that's what I was a afraid of. I have no probems generating the map from the xml but the end user isn't as savy, so I was hoping there was a "wizard" type solution that I wasn't aware of, so I don't get sucked down the forever supporting role on this one. In JMP there is an option in the import menu for these. So it is possible,
... View more
Is there a way to import TRIPLE S files into SAS easily? (without having to create the xml map and generating code to read in the data file) I've looked on-line and the only references were to use JMP to do it.
... View more