[AccessD] Microsoft Web Browser control on Access form - Odd behaviour with Excel 2007

A.D.Tejpal adtp at airtelmail.in
Mon Jul 13 03:44:24 CDT 2009


    Microsoft web browser on access form affords convenient means of user interaction with an excel file (e.g. selecting the start cell for data to be exported from access). It has been working fine with excel versions upto 2K3.

    However, it is observed that in case of excel 2K7, the excel file in question does not remain contained within the web browser. Instead, it gets opened independently in its parent application. Typical command in form's load event is given below:

    Me.MyWebBrowser.Navigate URL:="<<ExcelFilePath>>"

    I would be thankful for any suggestions for ensuring that the called excel file gets displayed strictly within the confines of web browser ?

Best wishes,
A.D. Tejpal
------------


More information about the AccessD mailing list