VBA macros and ActiveX
Posted: Fri Jan 31, 2020 3:10 pm
I am attempting to read an xlsm template file containing macros, write new information to some cells, and then save as a new xlsm file preserving the macros. There is a complication as there are a number of different ActiveX controls in the workbook that I would also like to be preserved. Can you confirm if this should be possible in version 6?
If it is possible can you give me an outline code example? At the moment I am getting a 'Duplicate File" error relating to image1.emf in the zip, which I believe is related to the first ActiveX control.
Thanks for any help you can offer.
If it is possible can you give me an outline code example? At the moment I am getting a 'Duplicate File" error relating to image1.emf in the zip, which I believe is related to the first ActiveX control.
Thanks for any help you can offer.