how do i add external binary files to an excel 2007 XLSB RRS feed

  • Question

  • I am creating a addin for excel 2007 that uses Business Objects Enterprise Desktop Intelligence to build queries and insert the returned data into an excel spreadsheet.


    Functionality I am looking to implement is:


    1. refresh data on demand
    2. store query files withte excel workbook and reopen the queries from teh excel workbook ( to allow item 1 above)
    3. multiple queries per worksheet

    I have worked out how to do items 1 and 3 .. my issue is storing the query binary files with the workbook. I thought this could be done with the XLSB file format for excel 2007.


    I was looking for a solution for wrapping the binary files into the XLSB.


    If there is a better solution I would love to hear about it.


    Jon O Roberts


    Thursday, February 14, 2008 3:42 PM