vba macro using DDE

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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.
 
Back
Top