What is wrong?

[mak]

I just finish a new bot which was working fine.After a restart of my pc i tried to log it to BA but it just open excel without any worksheets!The same happened in my laptop where i just ask to open the file & not log it BA.

With alt + f11 i can see the code & the sheet which are set to visible but not the actual sheets!!

Any ideas how i can solve this?

[osknows]

Does your workbook open ok without linking to BA? If yes open the VBA editor click Debug/Compile VBA project and let us know what happens

[mak]

No it still doesn't open the sheets

It is like a hide workbook.Even in the excel title it just says book1 instead of horses bot.If i am going to close the file though ask if i want to save changes in horses bot...

[mak]

As i can see now i "lost" one more workbook

I think it has something to do with "link multiple sheets quick link" because what i did in first place it was to made new links for this 2 workbooks

Gary any ideas?

[mak]

version 110.66x15

[GaryRussell]

From what you are saying something is not visible in your workbook even before you link to BA. Is this correct? If so then it cannot be BA that caused this. Does BA have a problem linking to new blank workbooks? If you can get this to work then it might be an idea to create a new workbook and copy your formulas and VBA into the new workbook and see if this solves the problem.

If BA is not finding workbooks then make sure they are all in the same folder if you are using multiple workbooks. Also try closing all instances of Excel, check if there are still instances running in the background using the task manager, end the processes then start again.

[Ian]

I've had exactly the same problem with a workbook recently.

Try Window -> Unhide .... I think you will find that you have the window hidden.

This also happened to me after using the "log multiple sheets quick link" so perhaps there is a bug ??

[GaryRussell]

I've had exactly the same problem with a workbook recently.

Try Window -> Unhide .... I think you will find that you have the window hidden.

This also happened to me after using the "log multiple sheets quick link" so perhaps there is a bug ??

I'll look into it, but I think it's unlikely to be bug. BA doesn't make any calls that hide windows/worksheets in Excel.

[mak]

Ian yes that was the problem !! (bug i think)
Now it is working
Thanks

* very strange ah