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!

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

Recent content by Pandab2002

  1. Pandab2002

    Help with number format in cells

    I am inputing account numbers in a cell. The cell is formatted for numbers with no decimal places. When I type in a number like this 1234567891115 it changes the last digit to a 0. Any suggestions?
  2. Pandab2002

    Finding the diferenced between two numbers in Excel

    I have a spreadsheed that tracks a weekly inventory. I am trying to find a formula that I can put in another cell that shows the difference between the number from one week to the next. Currently, I simply use something like =SUM(B2-A2). It works okay, but I have 100 rows of data, some data will...
  3. Pandab2002

    Naming capture files

    Thanks both of you for your outstanding suggestions. I wish i sent this earlier but it resides on my work PC which is not networked with this one. Anyway, here is the script that I built last week. string Da, Fs, Fu, dcf proc main capture off Da = $DATE Fs = "/" Fu = "_" s0 =...
  4. Pandab2002

    Naming capture files

    Hi all, I created a simple script to go in and pull data from a nortel pbx and capture it to a file. I am trying to come up with a way to fetch the telnet entry name and concatenate the entry name and the current date and use it as the capture file name. However the fetch dialentry dialname...
  5. Pandab2002

    save as help

    Thanks Fr33dan. I mad a couple modifications and it works like a charm. Here is the finished product. Dim folder$ Dim FileName Dim WorkbookName WorkbookName = "xyz.xls" folder$ = "C:\Documents and Settings\Administrator\" Workbooks.Open folder & WorkbookName...
  6. Pandab2002

    save as help

    PHV, I clicked record and did everything manually for 10 saves. It works, but there must be an easier way. Paul
  7. Pandab2002

    save as help

    Thanks Roel, The contents of column "I" are a 3 digit code and an airport code. "010_MCI" for example. I have two spreadsheets open, the one with the 132 rows containing the information above, and another spreadsheet, which I want to do the save as command 132 times. In the end, I want 132...
  8. Pandab2002

    save as help

    Hi. I have an excel spreadsheet the has 132 rows of information. I am trying to come up with a way to use the data in column "I" as "save as" file names for another spreadsheet that is open. In other words, I want to select the contents of "I2", do a CTRL-C (to copy), the select the other...
  9. Pandab2002

    converting formulas to real numbers

    Hi all, I have a spreadsheet with about 200 countif statements in it that rely on other spreadsheets being open. Is ther a way to change the contents of those countif cells to real numbers rather than formulas?
  10. Pandab2002

    Help with waitfor command

    The command when suspend at the end of the when lines seems to have done the trick. Thanks.
  11. Pandab2002

    Help with waitfor command

    geirendre, Thank you very much for that script. I tried that, it does work within reason, however, within the results of the prt command, some of those prompts occur. The CUST prompt, for example, occurs in every TN that is printed out. It looks like each time that one of those prompts are...
  12. Pandab2002

    Help with waitfor command

    No, there is nothing after "TEN ". I'll goof around with when target. Thanks.
  13. Pandab2002

    Help with waitfor command

    I am trying to write a script that captures a tnb dump from a nortel pbx. Here it is...simple right? proc main caprure on transmit "ld 20^M" waitfor "REQ: " transmit "prt^M" waitfor "TYPE: " transmit "500^M" waitfor "TN " transmit "^M" waitfor "CDEN " transmit...
  14. Pandab2002

    Copying comments to cells

    I have a simple spreadsheet that is a site directory. It has various telephone numbers and IP addresses entered as comments. There are a couple hundred of them. Is there a way to quickly copy all these comments into cells? Any help would be appreciated.
  15. Pandab2002

    Dending DTMF tones through a script

    Thanks. I'll give it a shot.
See more

Part and Inventory Search

Back
Top