Search results for query: *

:o) I've got several files all with the same name in a directory (ModelCompMMDDYYYY.xls). The current day file has a need to pull some historical values. I have a cell, D5 that contains the historical date (MM/DD/YYYY) for the data I am interested in finding. I'd like to pull the date and...

=MID(RtGet("Telerate","19901","IRGROW 18"),21,7) Trying to determine what this guy pulls. Telerate is the service the data is being pulled from and 19901 I'm guessing is the specific view/screen....do you think the IRGROW 18 is the 18th row? the 21,7? Thanks, Matt

I have a square with one connection point per side. I have X lines that I would like to each be connected to the square in different locations. X>4 and I actually would prefer that all of the connections are on a single side of the square. Is there any way to add connection points on the...

Worksheets: Worksheet 1 Data Cell A1 = always displays the current date Cell B4 = 1 Month Rate (I need to pull from WS #2) Cell B5 = 2 Month Rate (I need to pull from WS #2) Cell B5 = 3 Month Rate (I need to pull from WS #2) Cell B5 = 6 Month Rate (I need to pull from WS #2) Cell B5 = 12 Month...

All, I have an imput file with only one line. That line has many (greater than 60K bytes). I want to read that line in 128 bytes at a time. Once stored, I want to output to a file the each 128 byte chunck to a separate line. How do I read in a line that long and store it so so I hold only...

I'm getting an error as follows when running a client on Windows 2k: "Failed to load control 'SSTab' from TABCTL32.OCX. Your version of TABCTL32.OCX may be outdated. Make sure you are using the version of the control that was provided with your application."

I have two text boxes and I want to tab between them in Excel. Sheet1.TextBoxGrp.TabIndex does not exist as a method? How can I accomplish this?

I'm running into errors with the following EXCEL worksheet. Sheet1.cboCollatType.Add ("PC") Sheet1.cboCollatType.Add ("REMIC") Sheet1.cboCollatType.Add ("BALLOON") I also tried the AddItem method.

I have a vector of transactions. In this vector any given transaction (temp) is either a "D"eliver or an "E"xpect. If the transaction is a deliver I want to output the data into a deliver file and if it's an expect I want to output the data in an expect file. I have a for...

Is there an IsNegative function of any sort? If no, what is the best way to determine a doubles positive or negative value? I suppose I could always cast to a string and then read the leftmost character. If it's "-" then negative and if not, it's positive (assuming leading zeros...

What's wrong with this...it's too simple? Sub InsertDate() If Worksheets("NothernTrust").Cells(1, 1).Value = Date Then 'Note that A =1, B =2, C=3, D=4, E=5, F=6, G=7 Sheet1.Cells(Row#, Column#) MsgBox "No action has been taken. This worksheet has alredy...

A sample line from an imput file as follows: 1,123456,SL,27,1/30/2003,,1000.00 I already read in line by line with no problems into a String variable called TextLine. 1) I want to verify after the first comma IsNumeric() = True and Len()=6. 2) I want to verify that after the second comma is...

I currently have a double: 1.9590447665E10 I would like a double: 19590447665.00 I thought I could use the NumberFormat class but I've been having trouble...I'm somewhat new to JAVA Best, Matt

Microsoft SNA Server mainstream support ends June 30, 2003. Extended, fee-based support is available to customers until March 31, 2008. Microsoft Corporation has established reasonable and consistent software life-cycle support policies and procedures. For more information about Life-Cycle...

How do i output a tab following: out.write("this is a test");

All... Contents of go.bat ftp -v -n -i -s:go.scr computerName Contents of go.scr user userId password ascii cd funds/test put SF_AD_03200301.DEL bye Each day there is a file generated that I need to FTP to the same location. The file name changes based on the date. The file name for the...

Wondering what the following 3 registry settings do and how they may impact the box. HKEY_LOCAL_MACHINE --> SYSTEM --> ControlSet001 --> Control --> Lsa --> restrictanonymous restrictanonymous must change to 0x01, currently all 0s HKEY_LOCAL_MACHINE --> SYSTEM --> ControlSet001 --> Control -->...

All, Plain and simple our LAN here at work stinks. It drops all drive mappings during the night (maybe because of imaging?). My problem is this: I need to map the Q drive each morning at 7:00am to ensure that a scheduled job can write output to that LAN directory. Can I automate this using...

All, If we have a script executed daily by a staff member to send files to a bank. Is there a way I can check files that were sent previous days or months? I guess I'm wondering if there is some sort of history log for a particular script? Best, Matt

I'm looking for a basic stencil that represents a folder. Anyone know where to find it? Does it come pre packaged?