Am using vbscript and excel.application object and reading values from that Excel
Using some code
Now in my Scenario that 1 excel is updating from another excel

<u>If I open these both excel using mouse and double clicking so excel xyz.xls updates another excel abc.xls
But if I open using Excel.application object it does not update excel file abc.xls </u>

My code Is
<font class="small">Code:</font><hr /><pre>

Public objExcel1
Public objExcel2

Dim WorkingFile
Dim WorkingFileSheet
Dim DataSourceFile

WorkingFile = "D:\Manish\Work\abc.xls"
WorkingFileSheet = "Strategy"
DataSourceFile = "D:\Manish\Work\pqr.xls"

Call OpenExcel(WorkingFile,WorkingFileSheet,DataSourceF ile)

Function OpenExcel(MainFilename,SheetName,DataFileName)
Set objExcel1 = CreateObject("Excel.Application")
Set objExcel2 = CreateObject("Excel.Application")

objExcel2.Worksheets("Spot Rates").select
objExcel2.Visible = True

End Function

</pre><hr />

Actually pqr.xls is automatic generated excel sheet from another system placed in my work directory which auto updates in every 30 minuts.

Guys any idea please!!!
Thanks in Advance