regarding VBA

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • santho
    New Member
    • Jul 2007
    • 2

    #1

    regarding VBA

    hi,

    please help me out in updating the particular cell value from Excel in the database.

    i have sorted out employee details from database using SELECT statement and the output of this statement will be in excel Spreadsheet.
    if i change any value in the spreadsheet and do save changes using a button which is coded to change in database, i need only the modified cells to be replaced in the database.


    regards,

    santhosh
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    Which part of this do you need help with? And what version of VB are you using? Is it standalone VB, or are you using teh VBA built into Excel, or Access?

    Comment

    • santho
      New Member
      • Jul 2007
      • 2

      #3
      hi,

      its built in VBA with Excel. and its office 2003 with SP2. nd the Database is oracle 10g.

      Comment

      • SkinHead
        New Member
        • Jun 2007
        • 39

        #4
        You say that you :

        'need only the modified cells to be replaced in the database'.

        I presume you mean the rows, not cells.

        You'll need a second 'snapshot' of the data in order to make the comparison to find which rows have been changed.

        You could put this in a second hidden worksheet.

        Question : How many users will be accessing the Excel at any one time ?

        If it is just one, then OK. If it's more than one, then there's other things you need to be aware of.

        Comment

        Working...