Hi All,
Someone help me please, I want to join database A (Primary) and database B (Secondary) with "All Records in Primary File". My trouble is when in database B there is no records (this is cause depend on automatic script before) then the macro is stop.
May anyone can help me? is there any script like in excel (On Error Resume Next) to join those databases?
thank you
mobbie
Offline
Last seen: 4 years 1 month ago
Joined: 11/09/2015 - 05:06
Hi mobbie,
Sorry for taking so long to get back to you. Here is something you can try. You first check to see if there are records in the secondary file, if there are you perform the join, if not you rename the primary file to the join fle name so any functions that rely on the join should work.
Hope this helps.
Brian