Results 1 to 2 of 2
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    import from a txt file... (2000 sr 1)

    Very long piece of code moved to attachment by HansV

    this macro import a data from a txt file.

    my problem is NOT import the data if in the variable VAR_DESCR is present

    or var_DESCR = "RIMBORSO FINANZIAMENTI"
    Or var_DESCR = "VERSAMENTO ASSEGNO DI CONTO CORRENTE"
    Or var_DESCR = "GIROCONTO"
    Or var_DESCR = "UTILIZZO CARTA CREDITO"


    i have insert this line:
    If Not var_DESCR = "RIMBORSO FINANZIAMENTI" Or var_DESCR = "VERSAMENTO ASSEGNO DI CONTO CORRENTE" Or var_DESCR = "GIROCONTO" Or var_DESCR = "UTILIZZO CARTA CREDITO" Then

    but it not work and import the record...

  2. #2
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Louisville, Kentucky, USA
    Posts
    134
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: import from a txt file... (2000 sr 1)

    I think you just need parentheses:

    If Not <span style="background-color: #FFFF00; color: #000000; font-weight: bold">(</span hi>var_DESCR = "RIMBORSO FINANZIAMENTI" Or var_DESCR = "VERSAMENTO ASSEGNO DI CONTO CORRENTE" Or var_DESCR = "GIROCONTO" Or var_DESCR = "UTILIZZO CARTA CREDITO"<span style="background-color: #FFFF00; color: #000000; font-weight: bold">)</span hi> Then

    The way you have it currently written, the NOT is only applied to your first test (RIMBORSO FINANZIAMENTI).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •