+ Reply to Thread
Results 1 to 2 of 2

dde link with a refered cell

  1. #1
    Registered User
    Join Date
    08-18-2014
    Location
    São Carlos
    MS-Off Ver
    2007
    Posts
    1

    dde link with a refered cell

    I want to use a dde link like

    =BIDS|COTC!'vale5,last'

    where BIDS is the application that gets the last quote of the share "vale5" .

    I want to have the share "vale5" to be obtained from another cell A1.

    If I use

    =BIDS|COTC!'A!,last'

    it does not work.

    I tried INDIRECT() . It also did not work.

    Any help will be really appreciated.
    jgrfilho

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,071

    Re: dde link with a refered cell

    Hi jgrfilho,

    If this is meant to be an Excel Function, you can't use 'BIDS' or any application as a Function name unless you create a User Defined Function called 'BIDS'.

    It might help if you explain what you're trying to do with what applications.

    Cheers
    Remember you are unique, like everyone else

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to create Folders listed in column and in specified path refered in cell
    By Harish Kumar M in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-10-2014, 01:27 PM
  2. Replies: 5
    Last Post: 08-14-2013, 06:16 AM
  3. [SOLVED] count the number of text occurences on the refered rows
    By Jul Stev in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-03-2013, 07:58 AM
  4. [SOLVED] if i sort cell that has link to another page how to keep link
    By steve Bahrain in forum Excel General
    Replies: 1
    Last Post: 08-16-2006, 08:25 AM
  5. Hyperlink-link so that when a cell moves the link also moves?
    By peters in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-15-2006, 01:30 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1