Unique Rows In New Workbook

  • Hello all!

    I have a CSV that I have imported into Excel. The column headers are always named the same thing, but not always in the same place. I am attempting to create a new workbook from the CSV Workbook. The existing code is below.

    What is happening is the code is running fine until it gets to loseDupes. The new workbook is created, the save as dialog box comes up, and the formatting gets done. And then it hangs. With the code above, I'm getting an "Application or user-defined error" (PC Load Letter? The ****'s that mean?). I'm really having an issue with getting the unique records from the CSV workbook, to the newly created workbook. Upon entering debug mode, all my variables look right, and all the files I'm pointing to exist and are open. Please help.

  • Re: Unique Rows In New Workbook

    How Much Are Willing To Pay?

    "The problem with designing vba code completely foolproof is to underestimate the ingenuity of a complete fool."

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!