Search results for query: *

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

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

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

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

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

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

Hello all, I'm trying to make a VBA macro which imports several text files, and places them into seperate worksheets of the active workbook. This can be done manually very easily by File Open and running the options of the Text Import Wizard. Consequently, the sheet can be moved to the original...

Hello all, I want to do something, but I'm not sure if it's at all possible. In Excel, I want to have a "pick from list" in a certain cell. The options in that list, should vary, depending on the number and names of the worksheets in the excel file. I have at all no idea wether VBA can be used...

Hi people, I just have a really stupid question here and I'm amazed that I haven't found the solution yet: In Excel, I want to create a reference to a certain cell, with a variable position. For instance: The number in cell C5 determines the column number of the cell to copy to cell D6. The...

Hello all, I hope that someone likes to help me with this 'problem'. I think that I need to create a macro for this, that's why I have placed this question here. This is what I would like to do: I would like to create an Excel sheet that can import data from a series of e-mails. In my...

Hello all! I have some small (I hope) problems with my motherboard. It's not a very new PC: a Pentium-2, 266 MHz. The diagnostics program SiSoftware Sandra reported that the IOQD was set too low. I have managed to find out that IOQD stands for 'In Order Queue Depth', but that's all so far. I...

Hello, My Windows 2000 wouldn't boot. It freezed everytime at the same point, during the graphic startup screen. A repair setup didn't help, so I decided to reinstall windows 2000. But setup freezes everytime during the 'scanning hardware' part. Is there a way to work around this problem? thanx!

Hello, I'm using a program called DigitalMicrograph that is used to analyse pictures from microscopes. The program supports scripts that are based on C. One particular type of pictures I'm using is diffraction patterns, which contain several rings around a bright center spot. (An example image...

I have a strange problem in Access that has to do with a problem I have bothered you about earlier. I want to make an [Event Procedure] which checks if a certain field is empty, and if empty places a certain text in it. But I can't detect wether or not the field is empty. I have tried: * If...

Hello, I've asked this question before, and received answers, but still haven't solved my problem. This is what I want to do: A form in which, after a certain text is entered, in an other field a value is placed which is a combination of other fields. For example, I enter a name in the field...

Hello, I'm creating a database and I'm wondering wether the following option exists. I want to a field to depend on another field. Is this field has a certain value, I want the other field to be disabled.(Although I'm not sure wether fields can be disabled at all.) What I mean with 'disabled'...

Hello, I'm quit a newbie on C++. I need to do something, that I believe shouldn't be very hard. I want to make a function that reads from a certain memory address, and for a certain length. For example: I give the function 2 arguments: The memory address, and the lenght of the data. Than the...