Modifying documents RRS feed

  • Question

  • I'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..

    Friday, December 5, 2008 5:22 PM


  • Hi 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:

    Visual Basic Interop and Upgrade

    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
    Saturday, December 6, 2008 2:37 PM