Auto link Excel sheet

[vanbuuts]

Hi all, my script runs at 12 noon each day and as I am not always in I open BA from task scheduler and my Excel sheet from a separate command.

However, is there any way to select the first market and auto connect to my Excel workbook?

[Captain Sensible]

Don't think there's any way to do it at the moment.

Any reason why you just don't leave BA connected to excel as your computer's on anyway? Plenty of us have BA and excel continually running round the clock, all the commands are there in excel to reload markets and go to first market etc

[vanbuuts]

Only reason being I have several other Excel processes that run through the night - but thanks for the info