Results 1 to 3 of 3

Thread: Read Excel and Write to New Worksheet

  1. Aug 2nd, 2010, 09:03 AM #1
    Sportster61
    Sportster61 is offline

    Thread Starter
    New Member
    Join Date
    Aug 2010
    Posts
    2

    Question Read Excel and Write to New Worksheet

    I am reading an excel file. When everything passes the edits, it is then written to a database. However, if any cell in the row fails an edit, I would like to write a new worksheet (called Errors) containing all of the information from the row which failed.

    Any help would be greatly appreciated.
    Reply With Quote Reply With Quote
  2. Aug 3rd, 2010, 08:29 AM #2
    amrita
    amrita is offline
    Fanatic Member amrita's Avatar
    Join Date
    Jan 2007
    Location
    Orissa,India
    Posts
    888

    Re: Read Excel and Write to New Worksheet

    Check this link..

    http://www.eggheadcafe.com/community...ing-vbnet.aspx
    thanks
    amrita
    Reply With Quote Reply With Quote
  3. Aug 3rd, 2010, 10:44 AM #3
    Sportster61
    Sportster61 is offline

    Thread Starter
    New Member
    Join Date
    Aug 2010
    Posts
    2

    Re: Read Excel and Write to New Worksheet

    I am getting it to write, but was coming up with a box everytime asking if I want to overwrite the existing file.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width