Copy Records from one excel spreadsheet to another excel spreadsheet

  • Thread starter Thread starter chris_quinn26
  • Start date Start date
C

chris_quinn26

I am trying to create a macro that will append records from one excel
spreadsheet to another excel spreadsheet with access 2003. Later I am
going to populate some cells with an existing table in my access
program, but this is my problem for right now. I want to leave all
records in excel because of my conditional formatting and formulas. Is
this possible? Any help would be greatly appriciated.
 
Hi Chris,

It's possible but not easy. You have to write VBA code that launches
Excel, opens the workbook, and puts the values into the appropriate
cells. If you search (e.g. at Google Groups) for something like

group:microsoft.public.access.externaldata export automation excel
formatting

you'll see the sort of thing that's involved.
 
Back
Top