Page 1 of 1

VBA macros and ActiveX

Posted: Fri Jan 31, 2020 3:10 pm
by IanW
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.

Re: VBA macros and ActiveX

Posted: Sat Feb 01, 2020 9:00 am
by larsa
Hello

Macros are supported but not ActiveX controls.