Hi Claus,

On 2016-02-05 23:21, Claus Busch wrote:
Hi Peter,

Am Fri, 5 Feb 2016 21:38:55 +0100 schrieb PeCoNe:

i enter in cell B4:
=Excel.Sheet.8|'D:\MyDocuments\Files\QtsXXX.xlsx'! '!Qts!dAEX'

and excel changes it to:
=Excel.Sheet.8|'D:\MyDocuments\Files\QtsXXX.xlsx'! '!Qts!DAEX'

your syntax is wrong. It should be:
=Excel.Sheet.8|'D:\MyDocuments\Files\[QtsXXX.xlsx]Qts'!dAEX

Sorry Claus, but then i get a #ref error.

I copied B5 to B4 and changed
\QtsXXX.xlsx'!'!Qts!dCAC to
\QtsXXX.xlsx'!'!Qts!dAEX
and now it is ok.

I also have also opened a second sheet to try a query from
http://www.beurs.nl/koersen/AEX/p1

monday i can see how that works.

bye peter