1. About the only thing you can do is convert them to CSV, which will import into Excel.

    About the only thing you can do is convert them to CSV, which will import into Excel.

    See less
    • 0
  2. You don't even need to use call: @ECHO OFF SETLOCAL ENABLEDELAYEDEXPANSION SET /A position=0 SET order=DEFABC FOR /L %%A IN (1,1,6) DO ( for %%b in (!position!) do SET sequence=!order:~%%b,1! SET some_variable_!sequence!=%%A SET /A position+=1 ) FOR /F "tokens=1* delims==" %%A IN ('SET some_variableRead more

    You don’t even need to use call:
    @ECHO OFF
    SETLOCAL ENABLEDELAYEDEXPANSION

    SET /A position=0
    SET order=DEFABC

    FOR /L %%A IN (1,1,6) DO (
    for %%b in (!position!) do SET sequence=!order:~%%b,1!
    SET some_variable_!sequence!=%%A
    SET /A position+=1
    )

    FOR /F “tokens=1* delims==” %%A IN (‘SET some_variable_’) DO (
    ECHO “%%A” = “%%B”
    )

    EXIT /B

    See less
    • 0
  3. Sorry for this non-answer, but I would start pinging from top down, to save overhead (not that it amounts to much, but...). I would ping Google first. THEN: If that succeeds, then presumably you won't need to ping the underlings, as they are all awake and doing their jobs and your program can sleep.Read more

    Sorry for this non-answer, but I would start pinging from top down, to save overhead (not that it amounts to much, but…). I would ping Google first. THEN: If that succeeds, then presumably you won’t need to ping the underlings, as they are all awake and doing their jobs and your program can sleep., ELSE: Then I would work downwards from there if Google failed: DNS, then ISP, etc.
    Altenatively, there is an “event-driven” option for schtasks on win7+, but not sure about Vista, which will run a task based on events (use switch: /create /MO ONEVENTS: “Xpath event query string”) which would be ideal for your purposes, but that’s all I know at this point, not having worked much with seven. Use Google “xpath event query string” or wait for someone competent (Razor, anyone? hint?) to help here. I figure if any live TCP/IP connection drops, an event would be triggered, and this setup would save a lot of overhead of constanly monitoring tcip connections “manually”. Meantime, I’m curious myself, so I’ll keep up.

    See less
    • 0
  4. I may be wrong but a batch can't have buttons. That looks like a script driven program. You can make a menued program that runs batches, whether it returns to the menu depends on the program

    I may be wrong but a batch can’t have buttons. That looks like a script driven program. You can make a menued program that runs batches, whether it returns to the menu depends on the program

    See less
    • 0
  5. try using %%1 see if its an escape issue. Not sure what you are attempting to do with this, as it seems that you would have to define the parameter.

    try using %%1 see if its an escape issue. Not sure what you are attempting to do with this, as it seems that you would have to define the parameter.

    See less
    • 0
  6. Sub FindRef() 'Determine last row with data on Main sheet lastMainRw = Sheets("Main").Range("A" & Rows.Count).End(xlUp).Row 'Determine last row with data on Sheet2 lastSheet2Rw = Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Row 'Loop through Main Column A and search for Ref # in Sheet2Read more

    Sub FindRef()
    'Determine last row with data on Main sheet
      lastMainRw = Sheets("Main").Range("A" & Rows.Count).End(xlUp).Row
    'Determine last row with data on Sheet2
      lastSheet2Rw = Sheets("Sheet2").Range("A" & Rows.Count).End(xlUp).Row
    'Loop through Main Column A and search for Ref # in Sheet2 Column A
     For nextRef = 1 To lastMainRw
      With Sheets("Sheet2").Range("A1:A" & lastSheet2Rw)
        Set r = .Find(Sheets("Main").Range("A" & nextRef))
         If Not r Is Nothing Then
          Sheets("Main").Range("C" & nextRef) = "Good"
         Else
          Sheets("Main").Range("C" & nextRef) = "Take A Look"
         End If
      End With
     Next
    End Sub
    
    See less
    • 0
  7. Is the cursor a larger block than usual? Just to check have you tried pressing the insert key to turn this off? Have you tried toggling the Ins key?

    Is the cursor a larger block than usual? Just to check have you tried pressing the insert key to turn this off? Have you tried toggling the Ins key?

    See less
    • -3
  8. Try running a Diagnostic: Running Microsoft Office Diagnostics from the Start Menu Click on the Start button Click All Programs Click Microsoft Office folder Click Microsoft Office Tools Click Microsoft Office Diagnostics Click Continue Click Run Diagnostics

    Try running a Diagnostic:
    Running Microsoft Office Diagnostics from the Start Menu

    Click on the Start button
    Click All Programs
    Click Microsoft Office folder
    Click Microsoft Office Tools
    Click Microsoft Office Diagnostics
    Click Continue
    Click Run Diagnostics

    See less
    • 0
  9. Not an animated one. Check the emails you receive and I don't think you'll ever see one with an animation within it, simply because of the limitations of emails and the email clients that read them. You can obviously put in static graphics, but as DerbyDad says the recipient would need to have theirRead more

    Not an animated one. Check the emails you receive and I don’t think you’ll ever see one with an animation within it, simply because of the limitations of emails and the email clients that read them. You can obviously put in static graphics, but as DerbyDad says the recipient would need to have their system set to automatically download all images for that to work, something a sensible email user would never do.

    See less
    • -1
  10. If you had such problem read this article https://social.technet.microsoft.co...You can try these methods to repair your corrupt Excel file.1. Try Open & Repair - File -> Open -> Open & Repair2. Open with Libre Office or Open Office - It has shown tremendous results in opening the corrRead more

    If you had such problem read this article https://social.technet.microsoft.co…
    You can try these methods to repair your corrupt Excel file.

    1. Try Open & Repair – File -> Open -> Open & Repair
    2. Open with Libre Office or Open Office – It has shown tremendous results in opening the corrupt MS Excel file.

    See less
    • 0