Unable to connect Bot to excel sheet any advice

[Snowman54]

The 2010 "click to run" version of excel does not work with BA as the Com Server will not connect the two. In order to enable the com server to connect you need to follow the following Microsoft instructions to change the 2010 version from "Click to Run" to the MSI based version:

Switch from Office Click-to-Run to MSI-based Office


The license is the same. You do not need a new Product Key.
If you have any questions, contact Microsoft Support.

1.Save all work, and then close all programs.
2.In Control Panel, open Programs and Features to see a list of installed programs.
3.Click Microsoft Office Click-To-Run 2010, and then click Uninstall.
4.To remove Microsoft Office Click-to-Run, click Yes.
5.Go to the Microsoft Office alternative fulfillment page.
6.Click My account.
7.Click Download, and then click Advanced options.
8.Follow the instructions.
9.To install the MSI-based Microsoft Office edition, run SingleImage.exe.
10.When prompted, type your Product Key to continue.

This info is important as PC World and others are pre loading the Click to Run version of Office 2010 on all new machines and will become more common place as members upgrade either their computer or version of excel

Kindest regards


snowman