> You didn't mention your error message but your problem is probably
> because RefreshAll is a Sub so you cannot assign the return value to
> collectiondestock. Get rid of the "Set collectiondestock = " and just
> use:
>
> Amibroker.RefreshAll()
I have done it ...
In fact by writting this I receive the message " = expected " and my
line is red .
I have done the same code but with a .txt file then the alone line
Amibroker.RefreshAll() ' is accepted in vbscript ...
It was tedious ...
Finally here is the solution with .xls file in VBA code
Amibroker.refreshall 'without the parenthèses
'very , very , very , very stupid isn't it ?
Thanks to the others who give me any informations on the kind of
bindings ....
