Search results for query: *

Skip, I would do that but... When the market closes each day the LIBOR and market curve data needs to be saved in a file for that particular day. A market dash board if you will. The sheet that I'm looking into now pulls one or two numbers from a prior day's close, a full month ago market...

: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 wish I had known this all along....this helps immensely. Now, how do I win the lottery? What about a good stock pick? :o) Thanks again...

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

Thanks so much skip....it worked beautifully!

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

Thanks Dan, I'll give it a shot

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

outDel = new BufferedWriter(new FileWriter(delFileName)); outExp = new BufferedWriter(new FileWriter(expFileName)); //All transaction modifications performed below. Check the method for details. //While the vector is not empty, keep looping for( intCounter =0...

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 tired the dot AddItem as well. I think that my problem is I need to populate the "Sheet1" ComboBox1 when the XLS is opened for the first time. I think that my Sheet1 object isn't valid and that is the reason the AddItem method isn't working. Private Sub Workbook_Open()...

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

Hattusas, In what particular cases would the formatting given by hologram not work? If I pass in a null value? Or extremely large numbers? Just curious. In this case it would be typical for me to run very very large number through this code...100B or perhaps more. ~M

This is still not working. I know that I'm doing something wrong.....?! I would like it always to spit out a long number (no leading zeros) and then my decimal and always two numeric placeholders after the decimal even if there are no pennies in a transaction. public String...

Funny....so I changed the name of my sheet from NorthernTrust to Sheet1 and now it works.... Prior to the change it was giving me an "Out Of Range" error..

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