Use Excel Sheet in Vb6

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mohan Krishna
    New Member
    • Oct 2007
    • 115

    Use Excel Sheet in Vb6

    Hi every one!

    Can we make an Excel workbook or worksheet used to store the data from the VB6 project, READ ONLY? So that no one can edit the cells when the file is opened!

    MK
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    Originally posted by Mohan Krishna
    Can we make an Excel workbook or worksheet used to store the data from the VB6 project, READ ONLY? So that no one can edit the cells when the file is opened!
    I expect you can just turn on the password protection in Excel. That way, anyone who opens the sheet won't be able to edit the cells unless they know the password.

    Comment

    • Mohan Krishna
      New Member
      • Oct 2007
      • 115

      #3
      Originally posted by Killer42
      I expect you can just turn on the password protection in Excel. That way, anyone who opens the sheet won't be able to edit the cells unless they know the password.
      Thank You !

      Can I do that in VB without opening EXCEL?

      Comment

      Working...