0

how to enable / disable using vba excel on (com add-ins) excel ?

enter image description here

braX
  • 11,506
  • 5
  • 20
  • 33
indra
  • 3
  • 4
  • Please Google before posting: https://stackoverflow.com/questions/48565694/enable-com-addins-in-excel-through-vba If you *have* already googled, please explain what you tried, and what problem(s) you had when trying, so folks don't waste time suggesting things you already looked at. – Tim Williams Jan 29 '20 at 00:16
  • okay thanks for the info very helpful. sorry maybe the keywords I am looking for are not specific enough. but thanks again – indra Jan 29 '20 at 00:19
  • but do not understand, Public Sub Connect_COM_AddIn(Name As String) Application.COMAddIns(Name).Connect = True End Sub Public Sub Disconnect_COM_AddIn(Name As String) Application.COMAddIns(Name).Connect = False End Sub im try error – indra Jan 29 '20 at 01:02
  • Please [edit] that code into your question, thanks. – BigBen Jan 29 '20 at 02:22

0 Answers0