Hello , I need your help ....

I connect my program with MS Excel Cell with another program
through special code .

where XXXX is variable and its value changes every second or more .

when I add this code in Any Cell in my Excel sheet .
the value of cell changes according to value of XXXX in my program .

This is my Request :

I want a method like macro or anything else that help me to

Transfer The Value of Excel Cell to be a new input in Access data base , automatically every time the value of cell changes .

More Details :

Suppose that we have Excel sheet and MS Access Data base .
I put the code to a cell in excel sheet .

the float number is : 100.00
After 1 second the cell value becomes : 102.75

Now, I want Program that can determine this change in cell value
and create a new row in access DB and add the new value ( 102.75 )
as a new row at my access data base .

and Every Time the Cell value update , the new value adds as
a separated new row at my data base .

and at the same time , I want a Time column in Ms access DB .
That Save the Time when every new value enter the data base .

<center>I want know How can I do that ??? and with any language ???

I will be very thankful , if anyone can help me
and Give me a good solution for this problem .</center>

thank you so much


Jake Anderson

You can use the following event to fire your DB updated code

Private Sub Worksheet_Change(ByVal Target As Range)

'MsgBox Target.Address

' Get the Target Value

' DB Update Code here


End Sub

You can also use Worksheet_Calculate() event also

Cheers
Shasur

to

http://www.dotnetdud.blogspot.com

thank you so much Shasur

Your reply is so helpful

Good Luck my Friend



Jake Anderson