Set Stored Values from file

[thatsmy2bucks]

Hi Dallas, all,

Is there a way to set a stored value which keeps getting recalculated (example: based on a macro, or from another program)? I tried to use the given template and had a macro running in it for a stored value which I needed in my bot, but BA complains with an error on the file being locked or not existent. On using a static value, it works fine. (I am not too well versed with VB so asking if there is a way around this)

Thanks for your help here.
Ash

[Silverthorn]

Haven't tried it but you can try moving your macro into a separate xlsm workbook and have it output a csv at timed intervals?

https://stackoverflow.com/questions/841 ... e-from-vba

[thatsmy2bucks]

Haven't tried it but you can try moving your macro into a separate xlsm workbook and have it output a csv at timed intervals?

https://stackoverflow.com/questions/841 ... e-from-vba

Hmm, that may work! If I keep the times of read (by Guardian) and write (by external workbook) at a set interval; I don’t see why it won’t.

Thanks a lot Silverthorn! I will give it a go

Cheers.
Ash

[Silverthorn]

No problem.. Let us know how you go.
When you come to setting up the timing in VBA this may help.

https://www.youtube.com/watch?v=l3kBuJtNLgU

[thatsmy2bucks]

Actually found a something like this already being done!

Thanks sniffer66!!

viewtopic.php?f=6&t=22924

Cheers!
Ash