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