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
Bookmarks