RSlinx with Excel

if any knows plz kindly help In Rslogix5000 by using GSV instruction how can i show date and time in excel sheet.how to conifgure rslinx with excel?

I have the exact set up at work. I can get you the example files but I won't be back to work until next week.

Very simply you can put a link through RSLinx OPC to the tags in the controller.

suppose you have the RTC data in a UDT

RTC.Year
RTC.Month
RTC.Day
RTC.Hour
RTC.Minute
RTC.Second
RTC.uSEc

Then in a cell in Excel you can put the formula...

=RSLinx|Target!"RTC.Hour"

Note that Excel does not report if this link is broken - to do this properly you need to write VB code.....

dont forget that in RSLinx you have to setup the topic "Target".
Go to the top menu 'DDE/OPC' and choose 'Topic Configuration'. It will open up a new window. Click the 'NEW' box onthe bottom and create a new topic. The above example uses the name "Target" so use that. Then on the right window select the path to get to your CPU. Click 'APPLY' when finished