Update VBA code
Budget: ₹1,500 – ₹12,500 INR
The VBA code that needs updating copies excel tables and graphics into word documents. The process involves ‘soft coupling’ Excel & Word by employing named ranges and named images. It allows us to update 4 yearly reports with tables and graphics from multiple excel files.
At the moment the code works well except that we need to run it several times in order to have all the coupled tables and images refreshed. Ideally we would like to run the macro once and have all tables and images updated. In the example in copy, I had to run the macro 4 times to have all these tables and images update in word.
Secondly images that are on a page with no text no longer align to the margin when the macro is run requiring us to re-align tables and images one by one. We would like all objects to remain correctly aligned, centre & top.
At the moment the code works well except that we need to run it several times in order to have all the coupled tables and images refreshed. Ideally we would like to run the macro once and have all tables and images updated. In the example in copy, I had to run the macro 4 times to have all these tables and images update in word.
Secondly images that are on a page with no text no longer align to the margin when the macro is run requiring us to re-align tables and images one by one. We would like all objects to remain correctly aligned, centre & top.