BookmarkSubscribeRSS Feed
paulsparrow
Obsidian | Level 7
Use to use sas2excl macro but when moving to a new company I was never able to get it to work. Then started using ExportToXL and loved it. However as of Thursday this week it doesn't work anymore. I suspect it has something to do with the May 5th patch update for Excel on security.

I have since loaded Excel 2003 and now it works again.

Is there a DDE process by macro that will work on Excel 2010. I need the ability to dump SAS data into various positions on the sheet and over multiple sheets. I am not a high level engineer and have trouble reading through long white papers so looking for a macro that I will be able to read and understand.

Thanks
Paul
1 REPLY 1
data_null__
Jade | Level 19
There was a similar thread on SAS-L which referenced this discussion at some Office forum it may be helpful.

http://tinyurl.com/3ko3enf

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

Discussion stats
  • 1 reply
  • 2653 views
  • 0 likes
  • 2 in conversation