Search Results - VBForums

Search:

Type: Posts; User: luca90

Page 1 of 13 1 2 3 4

Search: Search took 0.05 seconds.

  1. Replies
    1
    Views
    86

    open and close Workbok in sequence....

    I have 3 Workbooks in the same directory.

    for example in c:\mydir\:
    Workbooks1.xls
    Workbooks2.xls
    Workbooks3.xls

    each workbook in Workbook_Open have a macro.

    i need to open...
  2. Replies
    13
    Views
    349

    Re: DEVIDE string in 4 parts

    tks Dilettante & jmsrickland i canot test now, but tomorrow
  3. Replies
    1
    Views
    121

    GET VALUE from html page.

    http://www.carifermo.it/it/Ricerca-ABI-CAB/

    in box "Codice ABI" of this page insert the value 01000

    press button "ricerca"

    I need, in this case to get the value of line: ABI: 01000 BANCA...
  4. Replies
    13
    Views
    349

    DEVIDE string in 4 parts

    PIAZZA LEVI, 11 - 15011 ACQUI TERME (AL)
    PIAZZA DELLA LIBERTA', 6 - 15100 ALESSANDRIA (AL)
    VIALE INDIPENDENZA, 63 - 63100 ASCOLI PICENO (AP)

    thi sis a lines in a txt file.

    i need to devide...
  5. Re: INTERNET EXPLORER as Chrome, FireFox object

    up!
    Sorry me.
  6. INTERNET EXPLORER as Chrome, FireFox object

    ....
    Dim objIE As InternetExplorer
    Set objIE = obj
    ....



    how to set instead Internet Explorer object, Chrome or Firefox ?
    tkx.
  7. Re: delete a pair of records with algebraic summ.....

    NO..
    exactlly this combination of valueS

    AAA BBB 100
    AAA BBB -100

    No summ with algebraic... similar

    AAA BBB 100
    AAA BBB -75
  8. delete a pair of records with algebraic summ.....

    I use ado and vb6 classic and access database...

    in table have:

    Field1 Field2 Field3
    AAA BBB -100
    AAA CCC ...
  9. Replies
    3
    Views
    187

    get currency value from web page

    http://cambi.bancaditalia.it/cambi/cambi.do?lingua=it&to=cambiGForm
    based this url...

    i have in a field of access table a dates similar:

    ....
    01/10/2014
    15/10/2014
    22/10/2014
    ....
  10. Replies
    3
    Views
    169

    CHECK if value is changed...

    I loop all line of txt file with the tipical:

    ....
    File = FreeFile
    Open "C:\TAB\TATI.txt" For Input As #File
    eccc..
    ...

    in txt have:
  11. Replies
    4
    Views
    156

    Re: loping throu all lines in object of email

    sorry i have just modified my first post, sse now.
    Tks sam
  12. Replies
    4
    Views
    156

    loping throu all lines in body of email

    I need to loop all lines in of email, possible?
    Tks.
  13. Replies
    18
    Views
    392

    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:-)
  14. Replies
    4
    Views
    423

    Re: hd usb samsung not revognized

    know you a free tool for tath?
  15. Replies
    4
    Views
    423

    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...
  16. Replies
    18
    Views
    392

    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...
  17. Replies
    18
    Views
    392

    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...
  18. Replies
    18
    Views
    392

    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.
  19. Replies
    18
    Views
    392

    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...
  20. Replies
    1
    Views
    140

    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.
  21. 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.
    ...
  22. Replies
    1
    Views
    174

    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 _
    ...
  23. Replies
    5
    Views
    261

    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
  24. 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?
  25. Replies
    7
    Views
    245

    Re: cursor and other option

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

    Re: cursor and other option

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

    Re: update record with summ

    TKS...but syntiax error
  28. Replies
    7
    Views
    245

    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...
  29. Replies
    3
    Views
    257

    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)
  30. Re: web page copy - get value from first and second page

    Hi West! tks! the code work perfect!
  31. 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.
  32. 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
  33. [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.:...
  34. Replies
    5
    Views
    228

    Re: copy file "one to one"

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

    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
  36. Replies
    8
    Views
    334

    Re: GET THE threenewest date in filed

    i'm in Access Database:-)
  37. Replies
    8
    Views
    334

    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
  38. Replies
    8
    Views
    334

    Re: GET THE threenewest date in filed

    HUMMMMMMM...

    i dont see the reference to table name.
  39. Replies
    8
    Views
    334

    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
  40. Replies
    3
    Views
    171

    Re: showall in excel sheet

    or just expand any affected rows, but check before if one or more column have an active filter...
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.