Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Provided Answers: 1

    Unanswered: Open office file in office from browser link

    Good day,

    I have a intranet page which displays multiple files that users can open. I need the files to open in the office application it needs to, for example Excel files must open in Excel. I have code that works:

    Dim objExcel
    Sub OpenEXCELFile(sFile)
    Call OpenWorkbook(sFile)
    End Sub
    Sub OpenWorkbook(strLocation)
    Set objExcel = CreateObject("Excel.Application")
    objExcel.Visible = True
    objExcel.Workbooks.Open strLocation
    objExcel.UserControl = True
    End Sub

    The problem with this is I need to change the Local Intranet secruity settings on each PC for the code to work properly. Does anyone know another way of opening a file in its application or otherwise how to programmatically change the local intranet security settings to LOW?


  2. #2
    Join Date
    May 2009
    I think you may be making it more complicated than it truly is. You should be able to just set them as links similar to what you would with other documents. For example:
    HTML Code:
    <a href="file:///I|/Public/TestForm.xls">Test Form</a>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts