Automatically linking BA and Excel

[macdos01]

Hi guys,

I have tried to search the forums so I do apologise if this has already been covered. I am trying to find a way to automatically link BA to Excel. Is there a way to programatically do this in VBA? or adding options when opening BA from the command line. If this isn't possible do any of you guys have a solution using other software/freeware - if so how reliable is it if it records mouse clicks etc?

Thanks in advance for any assistance.

[alrodopial]

Use the 'Excel/Log multiple sheets quick link' from BA menu

[macdos01]

Is there a way to use that automatically from VBA?

[Captain Sensible]

Any reason why you need to do it via VBA? It's only a mouse click on BA to open up open up excel and all worksheets etc won't quicker having to load excel etc. Plenty of options within BA to clear and reload the next days markets if you want things to run continuously

[macdos01]

Full automation, which includes when my computer restarts either from a power outage or an automatic update I would like to be able to have BA and Excel load up automatically (easily achieved) and then linked.

On a side note I found that when I used 'log multiple sheets' the first sheet (of 6) didn't actually link but the other 5 did.

[alrodopial]

Use a mouse recording program to access the 'log excel quick link' ,
"mouse recorder pro" is free

[GaryRussell]

As suggested a macro recorder is your only option at present because the program does not currently provide an automatic way .

[macdos01]

Ok, thanks for letting me know - I'll go down the recorder path.