Project Description:-

> We are developing one real time application which transfer real stocks data from one server(s1) to another

server(s2).

> There is one excel file on server(s1) which is continuously updated and we need to transfer those updated

data to server(s2) in every single seconds using tcp or udp connection.



-->For achiving this functionality we implement following method:

    Method :--
               - First create macro for getting address and value of updated cell in excel sheet.

                 Macro Code ---
            ***

            Private Sub Worksheet_Change(ByVal Target As Range)
                Dim VRange As Range
                    Set VRange = Range("A1:P100") ' input range


                        Dim address As String

                        address = Intersect(Target, VRange).AddressLocal

                    '' Get updated cell value
                        Dim cellval As String

                        cellval = Intersect(Target, VRange).Value

            End Sub

            ***

        - We Create one vb.net window application for sending updated values from server(s1) to

      server(s2) using udp.

I am facing problem that how can i get macro variables value in vb.net application so that those values are

transfered to server(s2).

If any one have any idea about this application or problem then help me.