excel macro scripting

Hi all,



I need to write an excel macro script to update records in globus.

I have refered the sample scripts and managed to write a script to input records in globus.But what i need is to identify if the record already exits or if its a new record.can any one please provide me such a script in VB which will identify if the record is an existing one or new record?



Thanks,

Samatha.

I am not sure whether this approach will work.



Write a main line routine to check the given record is exists or not. Then before doing your actual transaction, call this main line routine and decide.




___________

Thanks

Hi Malai.



I got a solution for this.The simple logic i used is to identify if its an existing or new record is to read the value from one of the madatory fields. If the value is null then the record is new one, esle its an existing record.



I would like to try out what you suggested. But how do I call the main line routine from the script?



Thanks.

Hi: may be a little late, but who knows you may need in ths future. Consider this option:



GLOBUSAPP.Func = 'S'
bdat = GLOBUSAPP.IDSet(recid, GLOBUSAPP)
UU = GLOBUSAPP.ID
If UU '' Then
ActiveCell.Offset(0, 1).Value = 'ALREADY EXISTE'
End If



This is a generic code for doing it.

Regards.