Unable to connect Bot to excel sheet any advice

[Snowman54]

Hi Russell & Gary,

I have been connecting the bot to my various excel sheets for the last 2 years with no problem, but today I have opened the bot and excel sheets as normal but the excel workbooks do not appear in the list when I click on the log current prices and open the box. I have tried every thing I can think off and wondered if you have any advice

Kindest regards


Snowman

[GaryRussell]

Does everything include rebooting your PC?

[Snowman54]

Hi Gary,

Yes have rebooted, uninstalled BA and reinstalled, even installed beta version, but each time I click on log current prices the worksheet box is blank whether I have 1 2 or 3 excel sheets open. Currently using Excel 2010 which has worked ok since changing from 2007 3 months ago,

The top box which allows me to browse for an excel file will fill when I go to a file, but not show in workbook or worksheet boxes, if i press refresh the details disappear out of top box and if that excel sheet is already open at the bottom it closes the excel workbook completely,

Have run anti virus scans, ccleaner to clean out cookies etc and run fix registry programme but nothing seems to work any help would be appreciated

Kindest regards

Snowman

[BlueBoy]

If you load excel and open a new workbook rather than existing bots will BA communicate with it?

[Snowman54]

Thanks Blueboy but have tried that and still nothing appears in the box when I try load the excel worksheet

Any one else with any ideas ?????


Kindest regards


Snowman

[Ian]

Can you log to a completely blank sheet ?

Do your sheets have vba code ? Have you changed anything ? I messed about with some code the other week and although I could see the workbook, the drop down box for the worksheet was blank. Never did get to the bottom of it - went back to the original which was fine.

[mak]

Did you install a newer version of Ba maybe.From a version which i don't remember now & onwards you need to have all the xl files in the same folder in order to appear in the drop down list..

[Snowman54]

Hi Guys thanks for your response, have tried blank sheet and still no sheet shown in boxes, have downloaded bot version 65x and beta version 66w and tried both still with no joy

Very baffling ????


Kindest regards


Snowman

[BlueBoy]

I have had problems in the past when excel has got into a hung state and it has been something to do with the
Application.EnableEvents = True
not being processed in the VBA code.

I overcome it by creating a macro with the statements

Application.EnableEvents = True
MsgBox ("Application.EnableEvents = True")
and assigning, say, CTRL/E to run it.

This brought my worksheets back to life.

Best of luck

[GaryRussell]

Might be worth re-installing Microsoft Office. It's COM interface may be corrupted.

[Snowman54]

Hi Gary & blueboy,

Have completely re installed Microsoft office 2010, having uninstalled the original, and again no luck,

Blueboy, is there a spacific cell you type the macro in, my sheet are all written in formula and not macros so not totally o'fay with macros


Thanks for all your help with this


Kindest regards


Snowman

[BlueBoy]

I am no expert on macros but you can try the following( I use Excel 2007-other versions maybe slighlty different)

1.Click on the macro icon to produce the drop down list and select record macro.

2 Choose a name and a letter to use to run the macro - i use e for enale events

3 Click ok. Go Back to the macro icon and this time choose stop recording

4Click the macro icon and choose view macros

5. Highlight your macro and choose edit

6.enter
Application.EnableEvents = True
MsgBox ("Application.EnableEvents = True")

7. Close the vba screen

8Try SHIFT/CONTROL and your chosen letter and hopefully you will see the above message.

Fingers crossed - hope this helps

[mak]

Maybe it's a very dramatic solution but could you consider reformating your pc or laptop.I can't believe it has something to do with macros ect because you already re install office.

[BlueBoy]

Although snowman has reinstalled Office I assume he has retained the workbooks he was previously using.

If so then these are the one constant that has not changed so it seems to make sense to suspect them rather than his pc.

[mak]

Probably you are right.It would help if he re installs office and try with a blank worksheet first?