locked
InterOp Files in Vb.Net & OWC11 RRS feed

  • Question

  • We are creating report using OWC11 component.
    Below is the code sample.

    mobjAPPXL = objAdmSys.ObjExcel

    wbkNew = mobjAPPXL.ActiveWorkbook

    strWorkbook = mobjAPPXL.ActiveWorkbook.Name

    mwsRates = wbkNew.Worksheets(

    "Rates")

    mwsReport.Cells(4, 1).Value = lngVols(intPeriodCode - 1)

    We are calling cells method again and again through loop,

    1. Will this call invoke interop.owc11 again and again ?

    We are creating an instance of OWC11 only once



    While we are running the code from local PC it's running without having issue but while it's running in Server it's taking long time.

    Could you please help to find out the root cause of this issue. 

    Friday, July 10, 2009 1:56 PM

Answers

  • Thanks for your question, this is not hte correct forum for this question. This tool does not use office component, and we don't have the office expert in this forum to help you with this question. I would suggest you to post this question in the Microsoft Office related forums.

    Thanks
    Monday, July 13, 2009 6:03 PM