Recent content by Hermanator

Unfortunately, I am not able to change the format of the data files. They come from a different program, and more people rely on them, so I can not change the output format. Instead, I have build a little loop around the QueryTable statement, which basically makes a QueryTable for each cell in...

Hello, I'm building an Excel sheet to analyze data contained in a large number (> 200) of text files, each containing 5 values. For instance, I have files: file0001.txt, file0002.txt etc, each containing VALUE1 VALUE2 VALUE3 VALUE4 VALUE5 I have build a VBA macro which uses the Excel function...

Of course, that's it. I failed to realize the significance of "VAR". It turns out that both y & z get changed inside the procedure, but that this change shouldn't be passed to the main loop. Thanks for your help.

I hope that somebody is able to solve this little mystery: I am working on a numerical simulation program. It calculates a certain device current and puts this in an output file. To keep track of the changes I make to the program, I compared the output files of different versions. After making...

Thank you for your suggestion. Indeed, that would be one way to solve the problem. However, I think that would be a rather time-consuming way since, in reality the range to be evaluated is quite large. So it has to go trough all cells to check if the value is <0. I was hoping to find a way to...

Hello, This is what I'm trying to achieve: I have a worksheet with 2 columns of data as follows: 1 A B 2 2 243 3 1 12 4 0 55 5 -1 1 6 -2 23 7 -3 12 I want to perform some calculations on these values, but only on the negative X-values. I can set a range in...

Hello all, I have made an Excel sheet that I use to fit some measurement data to a theoretical model. The model is a bit too complicated to fit it automatically, so I fit it manually by tuning a number of parameters. I would like to have a cell display a value as a measure of the accuracy of...

Hello all, I am trying to write a macro in Excel that calculates the CIE color coordinates from a given spectrum. For this I have to calculate the integral of the product of two functions: I = INTEGRAL [ g(X)*h(X) ] dX Both functions are in my excel sheet as 2 arrays. For instance column A...

Whoohoo! Thanks combo! Local:=True does the trick! Just curious: what does Local :=True do actually? The VBA help file doesn't say. About the .CSV format; I realise that using a semicolon as a separater isn't the correct format for a comma separated file. However, when I start a blank workbook...

I know that both OpenText and Open require paremeters. In both cases I correctly use the parameters to set the import options to Delimited, and set the semicolon as delimiter. All of the following options do not work. The file is is opened, but the data of 1 row is put in a single cell...

Hello people, I'm busy programming a simple macro. As part of this macro, a .CSV needs to be imported. The .CSV is formatted as follows: 0.500; 100 1.000; 200 1.500; 500 So a semicolon seperates different columns, and a line-end goes to the next row. I can open the .CSV files without any...

Both options don't work. Excel freezes when I use Open & Repair and it also freezes when I link to the data inside the sheet by the method as described in the FAQ......

Hello all, I have a problem with a .xls file that I have on my HD. It's completely unaccessible. When I try to open it with MS Excel (Excel 2002, Office XP), Excel just freezes. When I try to copy it with explorer to another folder or disk, explorer freezes. When I try to copy it with Total...

Sorry, I haven't been completely clear. Although I'm on a network, the problem isn't network related. Since the file is located on the hard disk, and can't be copied anywhere else (every program that tries to copy it freezes). In the mean time I have found this article on MS Knowledge Base...

Hello all, I have a strange problem, and have absolutely no clue how to solve it. There are a number of files on my HD, that are completely un-accessible. I can't open them and I can't copy them to any other location, with any program. I first had this problem about a week ago. It concerned...