How can I get macros to capture all my actions, like in Excel?

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

Guest

Here's the situation.

I have a master file. Let's call it A. I have a continuously downloaded file
that needs to be appended to A. Let's call it B. So basically I need to
append all data from B into A without erasing any data in A.

In addition, A and B both have the same header row. When I append B to A, I
would like for this header row to be deleted and for the rest of the data to
be appended to the next availabe row in A. In other words, I can't have any
null (blank) values in the data ranges.

I can do all this in Microsoft Access, but there is only 1 problem. I don't
know how to do macros to capture all my actions to get a final output of 1
file. Can you please help me with this?
 
ACCESS does not have a "macro recording" feature. In fact, ACCESS macros are
not at all like EXCEL macros. EXCEL macros are the "sister" of ACCESS VBA.
 
Back
Top