function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
lasw10lasw10 

Connect for Office -- issues...

I have recently installed the latest Connect for Office add-in and have various issues with it:

a) it seems impossible to "uninstall"...
Although listed in VBE is not available for removal via standard Add-In menu bar (as it should be) nor is it available via software removal.

b) it is impossible to call Application.Quit without getting the dreaded Type Mismatch error on doing so -- given you normally only run BeforeClose events when you are automating tasks this is obviously a pain.

Can anyone shed any light on how the add-in can be removed ?

Given the Add-In is protected it's impossible to fix whichever variables are causing the problem in the SFDC.xla so removal is only option.... it's a shame it is protected as it would be nice to have some control oevr where the toolbar positions itself on initialisation etc... and to be able to monitor handling of proxies on connection.

Thanks,
lasw10lasw10
Resolved.

To add the SFDC.xla to the standard XL Add-In list:
  • First locate the SFDC.xla
    (most likely unless moved previously it will have installed in the XLStart folder which is the source of the problem in many ways...)
  • Go to the Add-In toolbar and browse to thte location of .xla file and OK to list.

To remove the Add-In or to make it an "optional" add-in to be added / removed as and when required:
  • Close XL
  • Move the add-in from XLStart to any other location you wish
    though for ease move to the Office\Library folder along with the other standard XLA files.
  • Re-open XL
  • Go to Add-Ins Toolbar and uncheck sforce listing  (name may vary)
  • Should be prompted to delete entry from list as file can no longer be found (XLStart file removed).
    Click OK
  • Add back by browsing to new location of SFDC.xla and add as new.

To test Add-In now "manually" activated:
  • Uncheck Add-In from list
  • Close XL.
  • Re-open XL
    (you should find the SFDC toolbar is not listed nor is SFDC.xla visible in VBE)
  • Add back by simply activating as per any other standard Add-In via Add-In toolbar (check)
Automating activation of "manually" activated SFDC Add-In:

You can of course bind the Add-In in the Workbook Open event and remove again on the close using standard VBA eg
Private Sub Workbook_Open()
AddIns("SFDC").Installed = True
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
AddIns("SFDC").Installed = False
Application.Quit
End Sub
*name of addin may vary pending versioning - check name via Add-In toolbar

Hope that comes in handy for someone.


Message Edited by lasw10 on 01-11-2008 03:05 AM