I have a loop dataset to use variables for Tabnames and SQL files. A Select to File is set to use a macro enabled Excel file that has a Table of Contents Tab with a couple of command buttons used for formatting etc… When the automation runs - it populates the data tabs perfectly but it strips out the command buttons on the Table of Contents tab.
Is there a way to prevent this odd behavior?
Thanks in advance for any help you can provide
Mary
hi retainiac,
What version of TDP you are using? (Help > About)
Please note that in 4.3 version we’ve made many improvements and when i simulate this scenarion in there it works fine while in 4.2 it really strips off the activex controls…
However if you would like a workaround, i would suggest you to replace the buttons with standard Shape objects (Insert ribbon tab > Shapes > choose some Rectangle) and where after it is placed you can right click on Assign Macro and make it work like any other button.
Martin