walterparaiso
New Member
- Joined
- Dec 26, 2017
- Messages
- 2
Dear all,
I am newbie in VBA and i tried downloading trial balance on monthly basis thru Macro and I have the following concerns in mind:
1. How can I amend or update the downloaded month trial balance which was run earlier with the correct and updated month trial balance? e.g. Nov-2017 trial balance which was run earlier and to be replaced by the correct and updated Nov-2017 trial balance.
2. Is there any particular VBA code(s) to prevent duplication of month trial balance i.e. preventive maintenance?
3. Is there any particular VBA code(s) to append the earlier month trial balance e.g.November-2017 with the latest month trial balance of same month e.g. November-2017 or any executable command to delete duplication?
Thank you very much for any help you may extend.
Kind regards,
Walter
I am newbie in VBA and i tried downloading trial balance on monthly basis thru Macro and I have the following concerns in mind:
1. How can I amend or update the downloaded month trial balance which was run earlier with the correct and updated month trial balance? e.g. Nov-2017 trial balance which was run earlier and to be replaced by the correct and updated Nov-2017 trial balance.
2. Is there any particular VBA code(s) to prevent duplication of month trial balance i.e. preventive maintenance?
3. Is there any particular VBA code(s) to append the earlier month trial balance e.g.November-2017 with the latest month trial balance of same month e.g. November-2017 or any executable command to delete duplication?
Thank you very much for any help you may extend.
Kind regards,
Walter