Posts by jonny

    Hi, Guys.
    I'm trying to extract a string from a cell when it delimited by space.
    For example, the function get a cell "CLICKING THE ABOVE BUTTON MEANS YOU AGREE TO YOUR" and a string "UTTO".
    The function will return "BUTTON" (whole string that contained "UTTO").


    Thanks

    Re: Extract Pattern From A Cell


    Sorry for inconvenience and for my english, all of samples is pretty nice , but not really what I'm lookg for.
    I will try to explain ..


    Function will receive two arguments:
    1. some cell with a string
    2. string with/without operators : underscore (_) or asterisk (*) , where (_) is one character and (*) is more then one character.


    Example attached in a drawing.

    Hi, Guys.


    Needs your help or a hint, I'm trying to write 'user-defined' function in Excel, that doing following:
    Getting two arguments: cell and 'like' pattern (_ _ , *, e.t.c).
    As a result returns data that match this pattern.


    For example:
    1. Cell = "golf car is really comfort", pattern = "_ _ _ _" will return "golf"
    2. Cell = "toyota is number one", pattern = "num*" will return "number one"


    Thank you.

    Re: Copy From Recordset Into Cell


    I did following and it works.

    Code
    recArray = rs.GetRows
            For i = 0 To UBound(recArray, 2)
                ' Showing Each Column
                For j = 0 To UBound(recArray, 1)
                   str = str & recArray(j, i) & "|"
                Next
                str = str & vbCrLf
            Next
            rng.Offset(0, 1) = str


    Thank you

    Hello, friends.
    Please help to find the mistake in a code.


    Trying to run Access query from Excel and a result to add to Excel.


    Re: Range Of Variable


    Dear JuniorVB,
    You may also use the following macro:

    Re: Columns Swapping


    I will try to clarify:


    Assume I have 4 columns in following order:

    • Description
    • Object Attached To
    • File ID
    • Universal Resource Identifier


    or in following order:

    • Description
    • Universal Resource Identifier
    • File ID
    • Object Attached To


    or in following order:

    • Universal Resource Identifier
    • Description
    • File ID
    • Object Attached To


    After swapping I must get following order only (fixed order):

    • Object Attached To
    • Description
    • File ID
    • Universal Resource Identifier


    oh, my english ;(

    Re: Columns Swapping


    Lets' assume that I have following order, or any other order:


    Date Last Modified
    Description
    File ID
    Is File In
    Object Attached To
    Object Type
    Size
    Type
    Universal Resource Identifier
    Version Identifier


    I must to swap that it will get the order below (sorry for english) :)


    Object Attached To
    Object Type
    Date Last Modified
    Description
    File ID
    Size
    Type
    Is File In
    Universal Resource Identifier
    Version Identifier