Search Results - VBForums

Search:

Type: Posts; User: luca90

Page 1 of 13 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    18
    Views
    299

    Re: regular expression and txt file

    HI Mark, the part of regex of your code, dont match the CB with numerical suffix....!!!!

    i can send in pvt a part of m txt file?
    Reserved data:-)
  2. Replies
    3
    Views
    92

    Re: hd usb samsung not revognized

    know you a free tool for tath?
  3. Replies
    3
    Views
    92

    hd usb samsung not revognized

    Wow!!!
    My usb hd not recognized !
    Peraphs i have disconnected with the standard procedure: from try bar, disconnect the ysb hd ecc...
    In other case i see it but when i double click: do you want go...
  4. Replies
    18
    Views
    299

    Re: regular expression and txt file

    ok... in case i use the regex, wath is the correct pattern?
    tks as usual.

    in other case with this code, work only the like statement(?).

    Option Explicit
    Sub LEGGI()

    Dim File As Integer...
  5. Replies
    18
    Views
    299

    Re: regular expression and txt file

    hI Mark...Olaf,
    if i have understand to the end of discussion, the correct pattern is:

    "(^CB\d{6})$"
    or
    "[CB]\d{6}$"

    or i need to use simply the code :

    If sCurrentLine & " " Like...
  6. Replies
    18
    Views
    299

    Re: regular expression and txt file

    ok tks for code. but the number after CB not is fixed i can after CB, 123456, or 789456, or 548851 ...

    see in my note.
  7. Replies
    18
    Views
    299

    regular expression and txt file

    I loop a txt to read line by line, with the tipical:

    Open Path For Input As File
    do While Not EOF(File)
    ...
    loop

    ecc....

    i need to find (with REGUALR EXPRESSION) the line in txt where is...
  8. Replies
    1
    Views
    98

    check date last modified file

    How to compare the last modified date of two file in different dir of c:\mydir\.... and \\mylandir\

    if effect i need to compare if the file in \\mylandir is newest respect the file in c:\

    tks.
  9. insert event copy in Private Sub Workbook_Open()

    I need to insert in Private Sub Workbook_Open() a VBA code to copy a file from a lan dir similar :\\mylandir\database\my.mdb in local c:\mydatabase\my.mdb.

    I know the vba code for this way.
    ...
  10. Replies
    1
    Views
    138

    multi seek in ADO, dont work

    Option Explicit
    Dim CONN As ADODB.Connection, RS As ADODB.Recordset
    Sub TEST_MULTISEEK()

    If CONN Is Nothing Then
    Set CONN = New ADODB.Connection
    CONN.Open _
    ...
  11. Replies
    5
    Views
    215

    work with closed workbook

    I need to get and write in a specified cell of shee, from a closed workbook?

    Note:
    I use Vb6 Classic
  12. hide Excel instance and show only the userform

    I have in Workbook open event a code to show a userform.
    Is possible to maintain active the userform and hide the Excel instance?
  13. Replies
    7
    Views
    211

    Re: cursor and other option

    Where is the rs filled? i dont see in any part of your code, or not?
  14. Replies
    7
    Views
    211

    Re: cursor and other option

    OK...
    But, only to understand, why i need to remove, this oprtion?
  15. Replies
    3
    Views
    202

    Re: update record with summ

    TKS...but syntiax error
  16. Replies
    7
    Views
    211

    cursor and other option

    Set RS1 = New ADODB.Recordset
    RS1.CursorLocation = adUseClient
    RS1.Open SQL, CONN, adOpenStatic, adLockReadOnly, adCmdText


    is this correct to open a recorset if my MDB reside over Lan...
  17. Replies
    3
    Views
    202

    update record with summ

    table SOMME

    AG DATA DIFF MASTRO POSIZ DCI
    100 26/08/2014 10 20 10 111
    100 26/08/2014 20 10 20 111/8
    200 26/08/2014 10 20 10 111


    table CASSA (result before query)
  18. Re: web page copy - get value from first and second page

    Hi West! tks! the code work perfect!
  19. Re: web page copy - get value from first and second page

    hi West the code work perfect! tks for tath.
    But i need to get also the value with the arrow-
    for test use the value circled in image attached.
    Tks.
  20. Re: web page copy - get value from first and second page

    tks.
    but i dont know the way to put in the three box the related value of:

    Codice ABI (es.: 03002)
    Codice CAB (es.: 05085)
    Conto corrente:01578

    and press: calcola cin e iban
  21. [RESOLVED] web page copy - get value from first and second page

    http://www.mutuissimo.it/iban-x.asp

    Based this url i need to get all value from the second page when i click, on:calcola cin e iban

    to test use:
    Codice ABI (es.: 03002)
    Codice CAB (es.:...
  22. Replies
    5
    Views
    200

    Re: copy file "one to one"

    TKS, but but i need to lop all files in dir1 and copy one to one in dir2...
  23. Replies
    5
    Views
    200

    copy file "one to one"

    I have 2 dir in c:\
    i need to copy all files, "one to one", from c:\dir1\ to c:\dir2\, and overwrite if in c:\dir2\ just exists the files from dir1.

    is possible, plese simple code.
    tks
  24. Replies
    8
    Views
    305

    Re: GET THE threenewest date in filed

    i'm in Access Database:-)
  25. Replies
    8
    Views
    305

    Re: GET THE threenewest date in filed

    SELECT DISTINCT TOP 3 cassa.[DATA CONT]
    FROM cassa group by cassa.[DATA CONT]
    ORDER BY cassa.[DATA CONT] DESC

    result:
    DATA CONT
    30/07/2014
    29/07/2014
    28/07/2014
  26. Replies
    8
    Views
    305

    Re: GET THE threenewest date in filed

    HUMMMMMMM...

    i dont see the reference to table name.
  27. Replies
    8
    Views
    305

    GET THE threenewest date in filed

    I need to get the top three newest date in filed... hot to with sql?

    example:

    FiledDate
    ...
    31/07/2014
    30/06/2014
    30/05/2014
    31/07/2014
  28. Replies
    3
    Views
    139

    Re: showall in excel sheet

    or just expand any affected rows, but check before if one or more column have an active filter...
  29. Replies
    3
    Views
    139

    showall in excel sheet

    Ho to check if one or more columns have a filter active and if condition is true expand all rows?

    in vba for excel please.
  30. Replies
    6
    Views
    174

    Re: INSERT icon from c:\mydir... in cell

    hummmmmmm....
    i need to loop 8.458 lines, and insert in the existing value of cells the icon on the right.!
  31. Replies
    6
    Views
    174

    Re: INSERT icon from c:\mydir... in cell

    No.
    i have posted a number range but i rially use a string not number....
    But is really possible to insert to right of string in the same cell a icon from path?
    Tks.
  32. Replies
    6
    Views
    174

    INSERT icon from c:\mydir... in cell

    I have a icon (gif) in c:\mydir\icons\ico1.gif

    i need to insert this icon to the right of this value similar:

    ws.Range("AG" & RIGA1).Value = Format(SDO, "#,##0.00")& " "&...
  33. Replies
    3
    Views
    159

    Re: Calculating "Trend" of Agoust 2014

    Simple, have a blank cell in range D2:H2 (E2 and G2 are blank) and D1;H1 (E1 and G1 are blank) this is the formula in J2;=trend($D2:$H2;$D$1:$H$1;$J$1).
    The result in J2 is #VALORE!

    the filled...
  34. Replies
    3
    Views
    159

    Calculating "Trend" of Agoust 2014

    Attached a simple sheet.

    I need to calculate the trend pojection value in column I2 for the Agust 2014 based the month in D1,E1,G1 and values in D2,E2,G2?

    If is possible in vba code, tks.
    ...
  35. Replies
    4
    Views
    193

    Re: run query via batch or shell

    Yes!
  36. Replies
    4
    Views
    193

    run query via batch or shell

    But peraphs stupid question....
    i have a .mdb in c:\mydir\test.mbd
    possible to execute sql query via batch or shell command?
    Tks.
  37. Replies
    3
    Views
    155

    Re: Passing varible from application

    ...variable in a macro
  38. Replies
    3
    Views
    155

    Passing varible from application

    I open a workbook from a click button in a vb6 form with:



    Sub OpenWb(strWorkbook As String)

    On Error Resume Next
    Set WSH = WBK.Worksheets(1)
    On Error GoTo 0
  39. Replies
    4
    Views
    860

    Re: no permit save or save as workbook

    ok work!
    But possoble to show a MSGBOX with a message, to inform the user of limitation?
  40. Replies
    4
    Views
    860

    no permit save or save as workbook

    Ho to vba code to no permit from the user to save or save as workbook?
Results 1 to 40 of 500
Page 1 of 13 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.