Recent content by Pandab2002

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?

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...

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 =...

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...

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...

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

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...

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...

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?

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

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...

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

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...

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.

Thanks. I'll give it a shot.