Friday, December 05, 2008 5:22 PMI'm using a third party to export the report document to HTML, TIFF, PDF, TIFF, TXT and XLS format. But I'm having a problem because my document has a link/url on it and everytime I exported it the link/url was also carried. I'm able to resolve the XLS document by using the code below.
Dim Excel_file As New Microsoft.Office.Interop.Excel.Application
Excel_file.Workbooks.Open(strPath & "\" & strFileName & ".xls")
Excel_file.Visible = True
Excel_file.Worksheets.Application.Columns.Hyperlinks.Delete() 'This will delete the link/url
Does anyone know how can I apply this to other document?
Your suggestion is highly appreciated.
Thanks in advanced..
Saturday, December 06, 2008 2:37 PMModeratorHi Erick,
This forum is intended for questions on the Open Protocols Documentation.
Your question seems to be related to implementation/design.
I believe that the forum below will be more suitable for your inquiry:
Discuss how to do upgrades of VB6 code to VB.NET. Covers questions on interop features, Interop Forms Toolkit, Upgrade wizard, but NOT for questions about VB6.
Thanks and regards,
SEBASTIAN CANEVARI - MSFT Senior SEE Protocol Documentation Team
- Marked As Answer by Alex MorrillMicrosoft Employee, Owner Monday, December 15, 2008 8:31 PM