+ Reply to Thread
Results 1 to 7 of 7

Evaluate expression to an argument

  1. #1
    Registered User
    Join Date
    09-03-2008
    Location
    Illinois
    Posts
    3

    Evaluate expression to an argument

    I'm having difficulty with making this type of macro (I think it's a macro) more generic:

    =CWIN32|Data!'CWEval|active|act("BR","OF->8255R0")|'

    Specifically, I'd like to refer to a cell (or combination of cells) instead of hard coding the arguments to the act("BR","OF->8255R0") portion of the above expression. This is an expression produced by a set of drop downs (I don't know much about the language) that connect the sheet to an external database (I think it's Access). At any rate, I'm not having much luck. I can construct the arguments in a different cell, but cannot pass that cell's contents to the expression without getting an error.

    Any ideas?

    Mike Bozovich

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hi Mike, and welcome to the forum.

    You need to incorporate the INDIRECT() function. Check that out first. If you have any problems then post back.

    HTH

  3. #3
    Registered User
    Join Date
    09-03-2008
    Location
    Illinois
    Posts
    3
    Thanks for the suggestion, but this does not work for me. I have attached an example file to further explain the problem.

    Mike
    Attached Files Attached Files

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hello Mike,

    Can't you just use straightforward string concatenation? e.g with the ACCT# in A20 use the following in C20.

    Please Login or Register  to view this content.
    HTH

  5. #5
    Registered User
    Join Date
    09-03-2008
    Location
    Illinois
    Posts
    3
    Thanks, but that's why I am inquiring - straightforward concatenation did not produce the desired results...

  6. #6
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464
    Hi,

    I don't understand why you think it doesn't produce the desired result, if the desired result is what you have in C4

    When I put the ACCT# code in A20 and use the formula I posted in C20, it replicates in C20 exactly the same result that you've hard coded in C4 as an example.

    What answer is my formula giving you?

    Rgds

  7. #7
    Registered User
    Join Date
    06-28-2004
    Posts
    1

    Unhappy Re: Evaluate expression to an argument

    Hi Mike,

    I had the exact same problem. The firm I worked for switched from GoSystem to CaseWare. I used to place account numbers/lead codes in separate cells in Excel, then modify the GoSystem formula using "&" to pull in the codes.

    I tried everything I could think of to do the same with the CaseWare formula's (concatenation with "&", indirect(), even downloaded a user defined eval() formula). Nothing worked. Finally I called the CaseWare technical support and was told that I could not do it. At this point, I gave up.

    What I remember of the explanation went something like this:
    "CWIN32" is not a formula or a macro, it is a call to an external program.

    Apparently the way Excel handles calls to external programs is a little different than the way it evaluates formula's and/or macros. It seems Excel calls the external program just as it is typed into the cell, it does not evaluate pieces of the cell contents which look like excel functions first.

    If there any any experts here on Excel calls to external programs, perhaps they might have a solution.

+ 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. Conditional formatting from an expression value
    By howes0421 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-09-2008, 01:50 PM
  2. Evaluate end of folder name
    By cindy75 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2008, 10:30 AM
  3. Replies: 1
    Last Post: 06-04-2007, 07:33 AM
  4. Question about an argument
    By SuitedAces in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2007, 04:02 AM
  5. Passing an argument that represents an object
    By cgi_pro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-19-2006, 06:33 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