Writing and reading Excel in windows 7 64bit
Thanks for your reply, but I can not use DDE as I am using WIN 7.0. Is there any way to write / read otherwise?
Microsoft has deprecated DDE in WIN7.0. There is one more option called IDropTarget. I am not sure about this option, however could not give you any better solution.
Please find the link which talks of working with handlers, DDE deprecation and Use of IDropTarget. Hope it helps.
There is also an Excel fix for this problem which is worth a try.
Close the excel program. Right Click on Excel.exe icon on your desktop.
Click on properties ---> Compatibility tab ---> Change Settings for all users---> Enable the run this program as an administrator box
Click Ok and restart Excel.
Hope it works.