I am new to VBA Macro Coding. In a prior life was proficient in original Excel Macro coding so I am familiar with programming logic but I am green in the concepts of opening and closing files and moving data between them.
I have a third party software program that exports to Excel. Plan A was to have an auto-executing Macro run upon this export but my research has found that this is not possible due to the way that these third parties launch excel.
Plan B is now to have an add-in Macro that can be launched that will perform the following:
(while in the active excel sheet that was launched by the third party)
1. Open a template file
2. Copy specific cells from the active sheet to a specific spot in the template (cell data is always in the same place)
3. Close the active sheet and make the template the active sheet
As an example, looking to copy values in cells b2, b3 and b4 from the active sheet to the template in locations c2,c3 and c4 respectively.
Have been attempting to derive this from questions/answers in other treads without success.
Any help would be greatly appreciated.
Bookmarks