#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,872
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Macro/VB Question DDE Question MadDog22 Excel Worksheet Functions 1 March 10th 10 02:47 AM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good davegb Excel Programming 1 May 6th 05 06:35 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you [email protected] Excel Programming 0 April 27th 05 07:46 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you [email protected] Excel Programming 23 April 23rd 05 09:26 PM
Good morning or good evening depending upon your location. I want to ask you the most important question of your life. Your joy or sorrow for all eternity depends upon your answer. The question is: Are you saved? It is not a question of how good you [email protected] Excel Programming 0 April 22nd 05 03:30 PM


All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"