Search results for query: *

money not the issue, just want to see different products out there if they exist....i.e. compare to see what they can offer.

thanks, i have seen the website is there any others that people know off...

ok can you check out http://www.turboexcel.com/ i think it will explain what i want ... just wondering if there are other programs out there like it

ok but i dont want to write the program myself i want it to work out the calculation itself and just use it as an addin

i dont need it to hold the iterations just ouput the data in excel

i am the user i need to run 1 million + simulations, excel takes a day (the excel spreadsheet if very well built but acnnot handle the sheer amount of calculations) i am looking for a way to speed it up...hence c++

i am trying to automatically convert my excel spreadsheet to c++ using a compiler. i.e. the program will rewurite the program in C with inputs the user chooses and output the required data

Is there a program that can compile and excel spreadsheet into C++ automatically?

does anyone know of a program to automatcially convert excel spreadsheet to C++ dll addin?

my problem is the text file is huge (ie. more rows than excel can handle...so i dont think it will work for me

oversight sorry, but still does not work...is it possible do a quere on a text file?

Is it possible to do a qurey on a text file i found a code that will output the data, now i just want to do the query but i can seem to get a where function to work (the text file is tab delimited)... Sub TestGetTextFileData() GetTextFileData "SELECT * FROM test.txt" & " WHERE field1=" &...

what i do currently is read line by line the text file and output the results (i.e. i built a simple query that reads the file and shoots out the data needed - around 55 rows at a time)

true, but surely not all ways are equal

thanks, but it seems quicker just creating an object and reading it in vba: e.g. Set fs = CreateObject("Scripting.FileSystemObject") Set f = fs.OpenTextFile("c:\myfile.txt", ForReading, 0)

got it to work but it seems just reading the text file is much faster...i guess i will sitck with that thanks for your help

ok i think i got it but i had to do it through Microsoft Query (i.e. not in return data to Excel)

i cant seem to do this even when i go to the end

sorry i can seem to do it i have excel xp, i go to data --> import external data ---> new database query ---> MS Access ---> choose file --> pick the fields ---> then i get the filter data but it does not let me choose a cell? thanks

is there a way to dynamically change this query, i.e. i want to loop through the field?