ExcelBanter - Question

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Question (https://www.excelbanter.com/excel-programming/451287-question.html)

Hallo,

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'

Why?

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

Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

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