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