Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|