Dear All,

I have a problem in Excel - VB programming. For the purpose of Customer
Reporting and information, I've develop a VB module to display customer
information and a link to open an Excel file for detail information.

The excel file contain datasource in other link.. So, How to bypass the
Update link dialog ?
I want the excel file is automatically update link without customer
needs to choose the option from that dialog.

At recent i've used this code to open excel:
Dim objApp As Object
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet

Unload Me

With frmExcelViewer
.IndexFile = Idx
.Show

.wbrExcel.Navigate strFilePath

Set xlBook = .wbrExcel.Document
Set xlSheet = xlBook.Worksheets(1)

.wbrExcel.SetFocus
End With



Your solution is expected


Thx,

Chin Yen