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!

  • Congratulations TouchToneTommy 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: mike101
  • Content: Threads
  • Order by date
  1. mike101

    Truncating Decimal Places

    I have an input and a calculation which creates an output. However, it makes many digits with the decimal point. I just want to have the single digit before the decimal point, and 2 digits after the decimal point (i.e. 1.23) instead of what I have now (i.e. 1.234567788) do you know how to limit...
  2. mike101

    Excel giving wrong equation

    Unfortunatly... it seems Excel is giving me the wrong equation. I've entered it into my TI-Calculator, and I get the same results as I do with putting the equation it gives me in a VBA script and calculating... so I know that I have the equation right cause they check out with each other...
  3. mike101

    Calculation Excel Sheet

    I have used my data to make a graph and a trendline. Excel has given me the equation in this format: y = 2E-21x6 - 4E-18x5 - 1E-13x4 + 4E-10x3 + 2E-06x2 - 0.0094x + 10.275 I am trying to make this work in VBA format as a calculation where I can input x, and get the value of y. I don't...
  4. mike101

    How do I check to see if a file exists?

    I am using a for loop to open and convert data. Workbooks.OpenText Filename:= _ "C:\Documents and Settings\All Users.WINDOWS\Documents\sciencefair\Wind data\06\" & date8 & "\" & i & ".dat", _ Origin:=xlWindows, StartRow:=1...
  5. mike101

    Error when substituting a variable

    In my script, I'm trying to have data grabbed and placed in excel as a list. Range("A1").Select ^ This works perfectly fine, but I want it to be a list, so I've substituted 1 with a variable, and the variable is the number I want it to be in. The variable is already declared, and I've...
  6. mike101

    Converting from Fortran to VB

    Is there any way to convert a Fortran script so that it can work in Visual Basic? Thanks.
  7. mike101

    Working with data in Excel

    I am trying to take the 2999'th value for the B column and the C column and place them in D1 and E1... then go to 2999*2 for D2 and E2, etc. Below is the code I have. Sub Macro1() Dim Counter As Integer Dim Y As Integer Counter = 1 Y = Counter * 2999 If (Counter < 5) Then...
  8. mike101

    Removing useless data from Excel spreadsheet

    When I open up a data file and have Excel seperate the data, it works fine. However, my problem is that this data file was created and formatted to be printed out, so at they determined how many lines would print out in a page, and on each page put a header that looks like the following: USE...
  9. mike101

    Converting database from Word to Excel

    I am new at VBA. I am working with data for a science fair project, and the data is very very very precise. The data is taken every .02 seconds. I do not need all of this data. Here is an example line of data: &quot;2003153 21:00:00.000 284.00&quot; I would like to have VBA somehow...
  10. mike101

    Odd shaped modelling, I have no clue how to do it

    I am trying to model our Electric Car (you can see it at http://www.ripplewine.com/3dsmax/electriccar1.jpg and http://www.ripplewine.com/3dsmax/electriccar.jpg) The top black canopy, I just can't model it. I've tried modelling by using Editable Mesh of a cylinder, a FFD Mofifier (cylinder) and...
  11. mike101

    Registry/Program Loading problem

    I had many registry problems and couldn't run programs due to a Virus. Fortunatly, I was able to remove the virus with Norton Antivirus, but then had registry problems. I then used Norton WinDoctor which fixed all my registry problems. The one thing that keeps happening now when I open every...
  12. mike101

    Rounded Rectangle Tool Quick Question

    With the rounded rectangle tool... how do I change the radius for it? Thanks.
  13. mike101

    Fullscreen Display

    We have our system all made up and nice, we want to show it full screen without the windows stuff around it. I imagine it's something simple, but I can't find it. Does anyone know? Thanks.
  14. mike101

    Preloader problem

    I have my preloader setup for dialup users that take awhile to have it load. The problem is (since it's a header) that every page it shows the preload percent going again. It doesn't reload the animation, but runs through the numbers quickly, but it's redundant and annoying. Is there a way to...
  15. mike101

    Problem with dynamic text

    Oldnewbie, I sent you the file with the problem, it is loading the variables from the news.txt file but it is not displaying it for some reason. I triple checked my variable setup, but can't find the problem. I think I'm missing something stupid, but I just can't find it. Thanks.
  16. mike101

    Problem with dynamic text

    I am trying to display dynamic text. It is loading the variable from the text file and the dynamic text has the same variable. In debug it shows that the text file is being loaded correctly. The problem is for some reason it does not show up. Also, can I use motion tweens with dynamic text...
  17. mike101

    Swapping from animation to scene

    I set up my frames to run the animation. It keeps looping infinitly though, how do I get it to stop and act as an interface (the animation is this menu system coming in and then being a menu after done animating) but it just keeps looping. Thanks again, I know I've been posting alot, I'm just in...
  18. mike101

    Problems with scenes/import

    I imported my Fireworks image and converted my parts into buttons and all and got them to work like I want (to highlight and go down when clicked, and to go to a site). The problem is, the Scene 1 has the 1 layer in it from the import on. All the layers come from Fireworks when you double click...
  19. mike101

    Modifying pictures

    I had to save my photoshop images to import to FLASH, but flash has nothing like the magic wand tool so the pictures edges are overlapping the underneath things and it looks like garbage. Do you know how to clean this up? Thanks.
  20. mike101

    Importing from Photoshop

    I made my banner in all seperate layers and all in photoshop. When I go to import I get the error &quot;One or more files not imported because there were problems reading them.&quot; I've tried multiple different .psd files, not just this one and all give the same error. I am using Photoshop 7...

Part and Inventory Search

Back
Top