none
VBA Project 2010 and Excel RRS feed

  • Question

  • Hello,

    Can we read with VBA the content of a cell in an Excel workbook without opening this workbook?

    Thanks
    Saturday, November 10, 2012 2:01 PM

Answers

  • You cannot. Your VBA code will need to automate the Excel Object and open the file (it does not need to be visible) and then use Excel VBA object calls to examine the contents of the cell.

    Brian Kennemer - Project MVP
    DeltaBahn Senior Architect
    endlessly obsessing about Project Server…so that you don’t have to.
    Blog | Twitter | LinkedIn

    • Marked as answer by WLID1966 Saturday, November 10, 2012 9:08 PM
    Saturday, November 10, 2012 6:02 PM
    Moderator