Open function RRS feed

  • Question

  • Hi all, Good morning,
    I am not able to open a excel file with below code.
    I am running this module in workbook before close event.

    Sub open1()
    Dim wb_dest As Workbook
    Set wb_dest = Workbooks.Open("Z:\EG MI Information\internal MI\Abhijeet\Investment_ops\project2\EO-OPR-SI-EFF-IND-11-0033.xls")

    born to code
    Tuesday, August 9, 2011 8:11 AM

All replies

  • What version of xl are you running?
    What happens instead of the file opening?
    Can you open any other file using your code?
    Where is the workbook with the code located?
       a stand alone computer?, a computer on a network?, a server?
    Where is the file you are trying to open located?
    Will the file open if you run the code from a new workbook in a standard module?
    Jim Cone
    Portland, Oregon USA .
    http://www.mediafire.com/PrimitiveSoftware .
    (List Files XL add-in:  finds and lists files/folders with hyperlinks)

    Tuesday, August 9, 2011 2:56 PM