data aquistion through excel

[gabbie]

I am currently gathering data in an excel spreadsheet by means of a msquery. I have created code to run an update via vba code. Thanks to your help! As each value that is updated in the spreadsheet, it is used in a formula to evaluate changes. Each time this change meets the alarm criteria, I need to log it in a file for further review. I know that I can create an if-then statement in VBA, but how do I get it to log or print on to another file(sheet) for further review, in order of occurance, keeping each time an alarm condition occurs?

Any help is always appreciated.

thanks,
Gabbie

[Sisyphus]

Hello Gabbie,
That isn't so difficult. You can write on another worksheet in the same workbook or you can write on any of the worksheets in another workbook. But in order for us to help you it is best if you show us the data and show us where you want them - we will find some way to do the rest.
So, the best way will be to design the worksheet that will have the alarm reports. Each alarm, I presume, will have one line. With the design of the worksheet will come the design of that line. So, you will ask for code to open the workbook, find the worksheet, write the line, and clsoe the workbook again. All of that action to be triggered by some even that you may or may not ask us about. The line to consist of data whose computation you may or may not ask us about. All of that will become clear with the design of the 'alarm' worksheet.
Once you have designed it, post it.
And tell us whether it isin the same workbook or another one.