Search:

Type: Posts; User: mintz; Keyword(s):

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    652

    Re: Format ZIP Code for Multiple Countries

    Worked great for me, thank you!
  2. Replies
    7
    Views
    652

    Re: Format ZIP Code for Multiple Countries

    Just tested couple of inputs, is it possible to validate (or correct) the length of the input? (e.g. US 1234 would be converted to 01234)
  3. Replies
    7
    Views
    652

    Re: Format ZIP Code for Multiple Countries

    That did the trick, works like a charm!
  4. Replies
    7
    Views
    652

    Re: Format ZIP Code for Multiple Countries

    Yep, just a typo for NL, should be "1613LC" and "1613 LC" respectively
    How do I go about the UDF option? I believe it will be easier to handle by first removing all space and dash from the input,...
  5. Replies
    7
    Views
    652

    Format ZIP Code for Multiple Countries

    In Sheet1 I have the following table of zip code formats:


    <tbody>
    ISO
    Country
    Format


    AU
  6. Replies
    1
    Views
    5,308

    API JSON POST Request in VBA

    I have the following JSON request sample code from an API service provider


    HTTP Method: POST
    URL: /services/shipper/orders



    POST /services/shipper/orders HTTP/1.1
  7. How to refer to values from a dynamic named range in VBA

    I have this table where where each column is defined in the Name Manager

    https://s1.postimg.org/7insyr35xr/image.png

    How do I pull a value (e.g. Region) into a variable, using the names I...
  8. Search folders for an image and import to cell in VBA

    I want Excel to search all folders located in
    C:\Users\Daniel\Desktop
    and find a folder called "X" (value pulled from A1)
    If such folder exists, and contains images, import the first image it...
  9. Replies
    8
    Views
    434

    Re: Find row of last occurrence

    One exception case, when the row above is anything other than xxxx-xxxx (e.g. "balance") it needs to lookup the row above till it finds a xxxx-xxxx combination

    ok:...
  10. Replies
    8
    Views
    434

    Re: Find row of last occurrence

    It seems to work great when the last order in Sheet1 has a "-" in the middle, but if it doesn't include a "-" the order doesn't get counted, how do I go around that?
    e.g. when I added 1038-4 it...
  11. Replies
    8
    Views
    434

    Re: Find row of last occurrence

    Yes just thought it would be easier to see what I'm trying from picture

    Here's the data:


    <tbody>
    Order
    Total
  12. Replies
    8
    Views
    434

    Find row of last occurrence

    In Sheet1 I have a list of order records:

    https://s28.postimg.org/nvly2zvbh/image.png


    In Sheet2 I have a list of payment records:
    https://s23.postimg.org/gkekwdm17/image.png

    In Sheet2, I...
  13. Replies
    3
    Views
    241

    Re: How to set range with variable row/col

    Forgot the .Value
    Thanks a lot!
  14. Replies
    3
    Views
    241

    How to set range with variable row/col

    https://s4.postimg.org/udt66esvx/image.png

    I'm trying to set X and Y as a range
    I then loop through rows 1 to 10
    In each iteration, I want copy the value from column Y into column x
    The x=y...
  15. Replies
    15
    Views
    5,118

    Re: How to get last element of a JSON object in VBA

    Ok got it, great! Thanks a lot!
  16. Replies
    15
    Views
    5,118

    Re: How to get last element of a JSON object in VBA

    That worked! I was able to access the last message using this:



    For Each Item In dicTrack
    Set checkpointsColl = Item("checkpoints")
    sMsg =...
  17. Replies
    15
    Views
    5,118

    Re: How to get last element of a JSON object in VBA

    I'm parsing it like Rick said using the VBA JSON converter:


    Set ParsedJSONDict = JsonConverter.ParseJson(JsonText)
    Set dicData = ParsedJSONDict("data")
    Set dicTrack = dicData("trackings")

    ...
  18. Replies
    15
    Views
    5,118

    Re: How to get last element of a JSON object in VBA

    HiRick

    That is a JSON response, I simply put the xmlHttp.response text in a string variable called JsonText

    JsonText = xmlHttp.responseText

    I have just tried:
    sMsg =...
  19. Replies
    15
    Views
    5,118

    How to get last element of a JSON object in VBA

    {
    "data": {
    "trackings": [
    {
    "tracking_number": "3A5V198427201",
    "shipment_pickup_date": "2016-10-31T23:49:00",
    "tag": "InTransit",
    "title": "3531",...
  20. Replies
    8
    Views
    423

    Re: Convert Formula to VBA

    Thanks a lot mark, worked great for me!

    Here's a different solution I managed to come up with
    sState = Right([A1], Len([A1]) - InStrRev([A1], ","))sCity = Left([A1], InStrRev([A1], ",") - 1)
  21. Replies
    8
    Views
    423

    Re: Convert Formula to VBA

    That worked great! How do I get the left part? (everything before the last comma)
    I tried Left instead of Right, it works when there's one comma like New York, NY
    but if there's something like...
  22. Replies
    8
    Views
    423

    Convert Formula to VBA

    =IFERROR(IFERROR(VLOOKUP(RIGHT(A1,LEN(A1)-FIND(",",A1)-1),2,FALSE),RIGHT(A1,LEN(A1)-FIND(",",A1)-1)),A1))


    The formula takes the State from a City&State field (i.e. New York, NY) or in case there...
  23. Replies
    5
    Views
    6,588

    Re: How to get Unix Timestamp in milliseconds VBA?

    All solutions worked perfectly thank you so much!
  24. Replies
    5
    Views
    6,588

    How to get Unix Timestamp in milliseconds VBA?

    I want to get the current UTC time in milliseconds since 00:00:00 UTC on 1 January 1970 (Unix Epoch TimeStamp)

    I tried this:

    DateDiff("s", "01/01/1970 00:00:00", Now())

    The result I am...
  25. Replies
    7
    Views
    24,296

    Re: Convert String to MD5 Hash

    Wonderful works like a charm! Thank you guys!
Results 1 to 25 of 117
Page 1 of 5 1 2 3 4