Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bcbm
  • Order by date
  1. bcbm

    Excel Help Needed....

    Depending on how much I would be ok. How much coding are you talking about.
  2. bcbm

    Excel Help Needed....

    The CIRCULAR REFERENCE was my problem, but I did not know how to get around it What I want to do is have 1 sheet with a colum for the list of football teams and a a colum with ratings that I assign. Then I want to have a 2nd sheet where I just enter the team name in colum A and have the rating...
  3. bcbm

    Excel Help Needed....

    OK, well I have this thing working pretty good. Any idea how I can update the rating field where the original rating came from. I tried to use the VLOOKUP and just grab from the cell that had the new rating, but excel tells me that I can't have a formula get a figure from another formula...any...
  4. bcbm

    Excel Help Needed....

    I'm not sure what the issue is yet. I'm just happy to have a simple copy working for now. The next step will be getting it to work on 2 sheets so it looks cleaner. I do have 1 more question now. I have my sheet set up that after the game the winning team gets a new rating value, I now want to...
  5. bcbm

    Excel Help Needed....

    Skip, Thanks for the help, but I found a really good web site with alot of examples and I have the sheet working. It turns out the VLOOKUP worked best for me if I just had everything on 1 sheet instead of trying to use 2 sheets in the same work book. Here's the web site if anybody else wants...
  6. bcbm

    Excel Help Needed....

    Skip, Thanks for the help. Do you know of any place I could get examples. I seem to get things more when I can see them work. Even something simple would be great.
  7. bcbm

    Excel Help Needed....

    Thanks, but 1 more question. How do I set the table array ? I looked through the Excel help file and I don't see it listed.
  8. bcbm

    Excel Help Needed....

    I would like to use excel to keeping track of football teams. I would like to have 1 sheet with 4 colums. col 1 for names, col 2 for wins, col 3 for loss's, col 4 for ties. Then in a 2nd tab of the same workbook I would like to be able to enter the name of the team and have it pull the...
  9. bcbm

    General Procomm Question

    Thanks guys, that worked. I didn't even notice the extra space in there when reading it.
  10. bcbm

    General Procomm Question

    I did a copy and paste of the script above, but when I compile it I get this error and I don't understand why. ASPECT (tm) Script Compiler Version 4.60 Copyright © 1992-1998 Quarterdeck Corporation. All rights reserved worldwide. TIMEOUT.WAS: Error C066 Line 5: Missing ENDPROC or ENDFUNC command
  11. bcbm

    General Procomm Question

    I have a general question about Procomm. I want to be able to send a keep alive command to peice of equipment every 5 mins. Any idea's how I could do it only when I'm not sending a command. I have tried looking at the metakeys but do not see how I could put a timer on it.
  12. bcbm

    Need help with Telnet using the connection directory

    ok guys, thanks for the help. I figured out why I was getting double showings in my logs, it was appending to my old files. I didn't notice that the box to over write the existing file was not checked.
  13. bcbm

    Need help with Telnet using the connection directory

    here is the whole code, but pretty much what I pasted in is copied 4 times so I only pasted in the one section. proc main integer iEntries ;Number of entries in dialing class integer iCount ;Loop variable string sName...
  14. bcbm

    Need help with Telnet using the connection directory

    The script logs in and checks the alarms then once it hits the last entry for the direcoty it does it again before moving on to the next directory. set capture file "LA_Nav" ;sets caputure file to the file named in file_date proc capture on ;turns on capture...
  15. bcbm

    Need help with Telnet using the connection directory

    This script is working great now, thanks for all the help. I just noticed that when it dials the seprate groups it goes through the group twice before moving on to the next group, any ideas. I'm using the example from above still. proc main integer iEntries ;Number of...
  16. bcbm

    Need help with Telnet using the connection directory

    thanks for all the help, the script works great now. going to start working on getting it to e-mail out but not yet, lol. last question thou, can I run a BAT file out of the script ???
  17. bcbm

    Need help with Telnet using the connection directory

    The port number I placed in the connection directory after the IP address. Getting to the equipment is fine, but even with setting the echo at half duplex. here's the error msgs I got Error C002 Line 29: Missing space between tokens Error C003 Line 29: Unexpected escape sequence Error C002...
  18. bcbm

    Need help with Telnet using the connection directory

    Still have not gotten the telneting with a port to work correctly yet, but still messing with it. My next question is can I use the " inside a line that I'm sending here's an example. transmit "add user "netops"\m^M"
  19. bcbm

    Need help with Telnet using the connection directory

    Knob, does procomm have a hard time with telneting to a port number. I have modifed the script to telnet to a port to send TL-1 commands and now the script will not close the capture file, I also noticed that in the TL-1 I don't see what the script is transmitting, is that normal also. It...
  20. bcbm

    Need help with Telnet using the connection directory

    I just checked a little farther and my problem started when trying to only dial the group I created. Here is the script, do you see anything wrong with it. proc main integer iEntries ;Number of entries in dialing class integer iCount ;Loop variable...

Part and Inventory Search

Back
Top