Don't really know what you mean. Probably because I haven't dealt wit
those posh new appplications that can use DDE. I have used DDE a bit t
use text files, but don't see how you can navigate screens in anothe
app. Presumably you get to base data somehow, which requires suitabl
access.

I use SendKeys to, for example, tab to the proper box and paste th
data using Ctrl+V.

Perhaps you can post a snippet of your Access to something else code
If it is VBA it should be practically the same in Excel

--
Message posted from http://www.ExcelForum.com