Macro to look up info from a closed workbook

Hi Everyone. I wonder if there is a solution for a procedure I do each day. Here is the description of the process.

1. I open file "A" on the drive p:/new_files

2. I open a file "B" on the drive o:/old_files. I always open the last saved file. The file names contains the date as well, this way I know when it was saved.

3. Using the "A" file With the help of the vlookup function I make a search on the file "B". I search based on the invoice numbers.

4. After the search I get the invoices which were not paid. I sort them in order, and send them to two different email addresses. There are two arguments (VM and VF). The VM ones I send to one address, the VF ones I send to another email address.

5. After sent I make a note in the file "A" that the invoice number has been sent on mail.

6. Than I save file "A" in the drive o:/old_files.

Next day I repeat the whole procedure, and then again...

Is there a possibility to open file "A" and then run a macro which will do all these steps? If yes, could someone help me to make this macro? Of course then I can provide more details.

Thank you in advance!

Hello hunsnowboarder,

Yes, you can update the files using macros so the process is automated. I would need to see "cleaned" (remove any confidential information) copies of the files to start writing the macros you need.

Thanks,
Leith

Thanks a lot Ross! I will check the files and clean them and upload it here soon! I hope you can help me! Thanks again a lot!