lava.alt

here is a little example of how to use excel for what you need ... this subrutine find how many times a value, that is between a range, appears ... i hope you find it useful ... Private Sub LoadExcelFile() Dim FileDir As String Dim Row, Col As Integer Dim xlsApp As Excel.Application Dim Book As Excel.Workbook Dim Sheet1 As Excel.Worksheet Dim Sheet2 As Excel.WorksheetOn Error GoTo xError ' Assign object references to the variables. Use ' Add methods to create new workbook and worksheet ' objects. FileDir = App.Path & "\MyFile.xls" Set xlApp = New Excel.Application xlApp.Visible = True Set Book = xlApp.Workbooks.Open(FileName:=FileDir, ReadOnly:=False) Book.Activate Set Sheet1 = Book.Worksheets("Sheet1") Sheet1.Activate Set Sheet2 = Book.Worksheets("Sheet2") For Row = 1 To 10 For Col = 1 To 5 ' here we view is the value of the cell ' is between the range we need If (Val(Sheet1.Cells(Row, Col)) > 1) And _ (Val(Sheet1.Cells(Row, Col)) < 10) Then Sheet2.Activate Sheet2.Cells(Sheet1.Cells(Row, Col), 1) = Sheet1.Cells(Row, Col) Sheet2.Cells(Sheet1.Cells(Row, Col), 2) = _ Val(Sheet2.Cells(Sheet1.Cells(Row, Col), 2)) + 1 Sheet1.Activate End If Next Col Next Row ' we save the changes Book.Save ' close the objects Book.Close xlApp.Quit ' clean them from memory Set xlApp = Nothing Set Book = Nothing Set Sheet = NothingExit SubxError:MsgBox "An error ocurred during the process"End Sub here is the matrix is use for the calc the results appear in the second sheet 8 15 7 13 58 4 12 5 14 1 12 4 3 51 63 5 5 3 12 8 2 2 6 18 3 5 5 3 95 43 11 1 5 5 3 3 4 5 2 1 1 2 6 23 7 8 54 83 62 121 and the results i obtained are these

those who think that firefox is slow you can improve the speed ... i really dont remember where is the topic but there are a few lines of code to increase the speed if you have broadband and it really works ... im fine with firefox ... i think is easier to use and have more advatanges ... but i still using sometimes IE because some website that manage confidential information dont trust in firefox, mozilla and all that stuffs ... theria arguments "that browsers are not testes for this seciruty level" ... so i think that we'll never get rid off of IE ... lets hope IE 7 bring us a better performance

wow thnx a lot for the tips ... i've been always interested in developing games but i never have the enough information for starting ... i try that website calle gameuniv ... t think i will start with an easy tutorial about deveopling games with visual basic ... greta man .. thnx a lot if someome cane give me an opinion about starting my first game with visual basic or mabe i can try with another language???thnx again man ???

i would suggest to wait until the 3 consoles are in the market so we can test them ... im a big fan of nintendo ... i like it a lot ... the gamecube was a very sad situation because nintendo keep on making funny stuffs for kids ... all their games were about mario ... only resident evil 4, great game ... i hope that for this new console they make things differente

well i have expirience working with dates ... the way i sugget you to mange the date is the next ... work with them as Long variables .... with the next formatYYYYMMDDso when you try to sort them, as they are numbers, for example a date of the year 2004 will always be minor of a date of 2005 with that base ... ex.february 1, 2004 -> 20040201 (minor)february 1, 2005 -> 20050201and the same is for the months of the same year ...february 1, 2005 -> 20050201(minor)march 1, 2005 -> 20050301and the same for the daysfebruary 1, 2005 -> 20050201(minor)february 4, 2005 -> 20050204so when you make a query to your DB like thisSELECT YourDate, YourDataFROM YourTableORDER BY YourDatethe result will be this20040101200402012004023120050101 ... and so onand when you show the date to the user yo only give to it a format as you want it dd/mm/yyyy or mm/dd/yy .. as you wish

i think you have spyware or some ads in your explorertry this software:spysweeper ... the website is https://www.webroot.com/us/en/, is a great software to remove all those crappy stuffs ...try it is a trial of 30 days ... just before you scan your pc update it and if you like it buy it

i have faith in nintendos resurrection ...

thnx a lot badinfluence just ill try the links post :(great r u musician???here is a link to my band "space" https://myspace.com/browser mandrilliathnx a lot again

make shure that your boot sequence is right and the cd-rom is eneabled for booting ... if those two things are right maybe you have a problem with your cd-rom ...try booting with xp cdrom ... win 98, me and 95 will not work because are made for fat partition not for ntfs, win xp partition, but maybe your xp is working with fat ...

yep actually win xo do that but not as deeper as is describe for the new version of windows ... i dont believe that our privacy is respected, actually a lot of programs send stats to their websites ... many programs do that ...by the other side is impossible to make a perfect operating system, if the use for making longhorn better i think is a good idea but if they r using it to make market stats ... shame on them ,... but sincerly i dont feel that win xp sp2 have a better performance ...

Hi .... actually i have a website hosted with Xisto http://forums.xisto.com/no_longer_exists/ is about independent mexican music and bands so some of them tell me that they want to share their files in the website, i told them that i cant upload mp3 files to the website, so om looking for an mp3 hosting so that bands can share their filesplz check out the website http://forums.xisto.com/no_longer_exists/ a lot

great ??? thz a lot that was one of my problems with firefox ... take a long time to load some websites ... but now anymore ... thnx ... the speed is notorious and is amazing nowthnx again

i trust more in firefox, first by the part of security , is great ... another ... you can customize it as you want, it has a lot of skins and plug ins, a lot of website have their personilized plugin for firefox to work with it .... the only problem that i have sometimes is that some websites never load ... never ever ... i dont know whats the problem ... if there are compatibility issues of whatever ...but definitively firefox

i cant see the image .... and the one in freeservers never shows and send a lot of popups ... like hell hehe

thnx??? i ve already try by applying the last config of the system that works ... but again the pointer of the mouse is not working ... you are right, i should not use ilegal programs but i was looking for a serial of a program that was out a of the market since 97 and actually is a problem to buy it thnx for helping me??? i think the solution will be to format the pc thnx a lot

yep i have the same problem and i dont know what to do ... my website is down ... and i post and post and the website never comoback again .... i dont know what happeni was reading in the forum and it says that when you have enought credit you website will be up again in a few hours and thats not true ... i also know is my fault but i cant get my website work againi need help ...please

yep i think dell is a good brand

yep you are right ... that service is given from a 3rd company ... is not given by google ... you have to send you account name and your pass so that they can log and send your emails to your mobile phone ...also i dont feel secure with that stuffs ... i prefer keep checking my gmail account in my pc

recently ive entered to a website called crackcrawler, that stuff installed in the pc of a friend like 50 o 70 spies and ads ... to removed all that sh*t was a problem, but finally we did it with the help of spysweeper ... in the beginning everything looks fine ... but the problem came later, the right button menu for all the system was disabled by some spy or an ad ... we dont know exactly which one ...as you can imagine is a very big problem trying to work with any program ...so i need your help ... if someone knows how can i fix that problem plz??? tell methnx guys

wow???great design ... looks very good, now all we have to do is wait to see the games cos thats whats really matters ... the outside is important by the side of the estethiuc but the power of the system is what matter for us

halo 1and halo 2 ...personally i dont like a lot the xbox but that game is one of the best i ever played

thats right ... you have to know to what are you making refence qhen you put "=", in this case to an atribute of a class, in this case a cell

yep the ads are a big problem and are worst when they websites have "malicious code", the bittorrent trackers are a problem because all are supported by ads ... but also we have to think that if there wweere no ads no trackers will exist ...yep this forum take a long time to load because of the ads

Jill from resident evil sweet ...

thnx Raptrex for the pic???the design looks great!!does someone has pictures of the games or a video???