vba macro using DDE

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JerryE - 22 Mar 2007 19:37 GMT

I'm new to VBA and I need sample macro code to import numerical data in
multiple cells of an Excel spread sheet to an Access database using DDE. Is
that possible?

Signature

je@sbc

Reply to this Message

Steve Schapel - 24 Mar 2007 20:23 GMT

Jerry,

Have a look at the TransferSpreadsheet action/method in Access. That
may meet your needs. Otherwise, you may need to use Office Automation
to process the data one cell at a time. If so, this is not an Access
macro question, and you would be better re-posting your question to the
access.externaldata newsgroup.

Signature

Steve Schapel, Microsoft Access MVP

> I'm new to VBA and I need sample macro code to import numerical data in
> multiple cells of an Excel spread sheet to an Access database using DDE. Is
> that possible?

Reply to this Message