Search results for query: *

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

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

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?

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.

Has anyone been able to accomplish this? I am interested in sending DTMF tones to a voicemail. Thank you in advance.

I have an Access database the is on a network drive. Everyone has access to this file and can update it. I want to be able to notify others when the file is opened and being edited by someone else. I'd like to be able to offer to open the file as a read only while it is being edited by another...

I have a column of 233 IP addresses. I'd like to be able to just click on any of the addresses to reach the web application associated with that IP address. I have tried using concatenate the IP address with a column that contains http:// but it does not create a link. If I manually type...

I have a spreadsheet that looks at a column in another spreadsheet and counts the instance of certain criteria. I use the following: =COUNTIF('[open.xls]Service'!$K$2:$K$60, 1) This works great. Now I want to apply the same logic usint the =SUMPRODUCT function to only count criteria in column...

I want to be able to quickly browse a spreadsheet to see how many items are "past due". I am trying to build a process that looks at dates in a column and compares it to todays date. If it is before today's date I want to count it, if it after today's date i want to ignore it. z = Format(Now...

Good afternoon all. I have a spreadsheet that contains trouble ticket info. I need to figure out how to select all the rows that contain certain words. I can figure out the cutting and pasting process, but I have been unable to find a command the looks at column H and selects the entire row for...

Is there a way to turn on the terminal window before dialing. By this. I don't mean activating a new terminal with the "menuselect PWMENU 326" command. I want to go into the advance modem properties and activate the "Bring up terminal window before dialing" option. Then I'd like to disable it...

I have a spreadsheet with two columns and 30 rows of data. Column A contains titles and column b contains mostly numbers. I am only concerned with certain rows. The rows in column A that I am concerned with all contain the phrase "XFER 1". I need to add the data in the neighboring cells in...

I have the following procedure as part of a larger procedure: Dim content(18) As String Dim c(18) As String z = 18 For j = 1 To z Windows(sName3).Activate content(z) = Cells(j, i) Cells(j, i).Activate If content(z) = "" Then Cells(j, i).Select Else Msgbox...

I am using the following to find data in an excel spreadsheet with 18 columns. Cells.Find(What:=content, After:=ActiveCell, LookIn:= _ xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _ xlNext, MatchCase:=False, SearchFormat:=False).Activate When I find the...

I am trying to create a macro that will open a file from a directory that contains about 200 .csv files. All the files have a 3 digit numeric name such as 101.CSV and 707.CSV. Id like to be able to open the first file perform some other macros, save it as a .XLS. Then open the next file. Any...

I am importing a csv file to a table in Access. It contains over 2000 rows and 16 fields (cloumns). I am only concerned with certain data in Field 1 and Field 2. Here is a sample of that data: SiteName Hurst TX UserSiteID 101 Partition 1 DateRetrieved 12/21/2004 13:25 Node Statistics...

Hi all, I am using the following script: integer a = 1 proc main string capname = $DIALCONNECT string cname = "TEST set dialentry access DATA capname set capture file cname set capture overwrite on Transmit "LD 95^M&quot...