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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Funkymatt
  • Order by date
  1. Funkymatt

    Excel: Dynamic file refrence

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

    Excel: Dynamic file refrence

    :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...
  3. Funkymatt

    Excel MID(RtGet())

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

    Adding connection points to a shape

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

    Adding connection points to a shape

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

    Search Column For Date - Extract Data to workbook #2

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

    Search Column For Date - Extract Data to workbook #2

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

    String of 128 bytes?

    Thanks Dan, I'll give it a shot
  9. Funkymatt

    String of 128 bytes?

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

    Failed to load control 'SSTab' from TABCTL32.OCX.

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

    Routing output to different files.

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

    VBA - Excel TabIndex?

    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?
  13. Funkymatt

    ComboBox Population: Excel

    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()...
  14. Funkymatt

    ComboBox Population: Excel

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

    Routing output to different files.

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

    IsNegative(double) ?

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

    Formattting a Double

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

    Formattting a Double

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

    Debug?

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

    Debug?

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

Part and Inventory Search

Back
Top