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...
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...
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...
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...
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...
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...
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...
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:
"2003153 21:00:00.000 284.00"
I would like to have VBA somehow...
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...
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...
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.
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...
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.
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...
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...
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...
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.
I made my banner in all seperate layers and all in photoshop. When I go to import I get the error "One or more files not imported because there were problems reading them." I've tried multiple different .psd files, not just this one and all give the same error. I am using Photoshop 7...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.