Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: jtm2020hyo
  • Content: Threads
  • Order by date
  1. jtm2020hyo

    What is wrong with this code?

    I tried: Dim Tag_List Function DefineTag(Tag_List) Select Case Tag_List Case "NAME" A1 = [B] Case Else A1 = "" End Select End Function DefineTag([A]) RETURN = A1 ... but do nothing, anyone could help me here?, not sure what is wrong here. [A]=AAA [B]=NAME WHEN B is a string "NAME"...
  2. jtm2020hyo

    VBA script to split 0D, 1D, and 2D arrays

    Hello, I found a nice formula to manage arrays, but I do not have idea why this do not work with 0D arrays (unique cell) and 1D arrays (rows or columns), but this work correctly with 2D arrays. for example, when I use this =JTM2dSplit(IFERROR(FILTER(M53:N60;L53:L60=1);"");";";";"), this return...
  3. jtm2020hyo

    Convert Formula to String (in solvable)

    I found an in solvable issue, I use AutoCAD MEP and this support VBS v3.0 if I remember correctly, everything work good but ... ... When I try convert create a tag for my object like "ABC-123", VBS read this like a formula, and I already tried everything in the internet to convert this...
  4. jtm2020hyo

    Push element to Array

    I found a function ().push in JavaScript to add elements to array. Is there any equivalent in VBScript to add elements to Array too simple like ().push?
  5. jtm2020hyo

    Convert a String to 2D array and Operate their values

    Convert String to Array then do basic operations: StringSource= (A1,B2,C1; A2,B2,C1; A3,B2,C2; A4,B2,C2;A5,B2,C3; A6,B2,C4; A7,B2,C5;) to 2DArray = {A1,B1,C1; A2,B2,C2; A3,B3,C3; A4,B4,C4 ; A5,B5,C5; A6,B6,C6; A7,B7,C7} using Split "," For Axis-X and ";" for Axis-Y and not sure that more...
  6. jtm2020hyo

    Suggest books

    Which ebook/book pdf could I buy (or read for free if possible) to learn advanced VBS (or VBA if there is not VBS ebooks/books)
  7. jtm2020hyo

    Count Repeated/Unique Strings/Values

    I have an Variable like this: ArrSource = A1,B2,C1; A2,B2,C1; A3,B2,C2; A4,B2,C2;A5,B2,C3; A6,B2,C4; A7,B2,C5; 'Note: ArrSource is String How can I count all "C*" repeated values, I mean something like this: 1) Convert Arr1 to multiple array: Arr1 = A1,B2,C1 Arr2 = A2,B2,C1...

Part and Inventory Search

Back
Top