Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Modifying documents

Locked Modifying documents

  • Friday, December 05, 2008 5:22 PM
     
      Has Code
    Sign In to Vote
    0
    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..
    erick
       

    All Replies

    • Saturday, December 06, 2008 2:37 PM
      Moderator
       
       Answered
      Sign In to Vote
      0
      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

      RSS
      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.

      http://social.msdn.microsoft.com/forums/en-US/vbinterop/threads/


      Thanks and regards,
      SEBASTIAN CANEVARI - MSFT Senior SEE Protocol Documentation Team