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

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?
 
K

Ken Snell [MVP]

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top