Only Adding New Table Data in Excel vba

Question

I'm trying to read data off a few files and create a new document containing the read data, which is easy enough using the workbook object.

However, I'm not sure how to only add data which has not been added yet without overwriting the previously written data.

Any help would be greatly appreciated, thanks in advance.

Is the data being overwritten the same as the data replacing it? — NickSlash
– NickSlash, Commented Jul 9, 2015 at 20:12
For the most part yes, only each element of the list I create will have a timestamp corresponding to the time it was added to the list. — sBourne
– sBourne, Commented Jul 9, 2015 at 20:27

Bond · Accepted Answer · 2015-07-09 21:44:20Z

2

You could read your data into a Dictionary object first. Dictionaries can be used to store a unique list of items. For example:

Dim d As Object
Set d = CreateObject("Scripting.Dictionary")

' Loop thru your file data, adding each value if it doesn't exist...
    If Not d.Exists(strData) Then d.Add strData, ""
' End loop

' Now add each dictionary item to your workbook...
Dim k As Variant
For Each k In d
    ' Add k to workbook
Next

edited Jul 9, 2015 at 21:44

answered Jul 9, 2015 at 20:11

Bond

16.3k6 gold badges34 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

sBourne Over a year ago

Thanks, I'll look into the dictionary object

NickSlash Over a year ago

Adding "Microsoft Scripting Runtime" to the VBA References adds the Dictionary object to IntelliType in the Editor which is handy if your learning about them. CreateObject is probably the best way over all as its more portable.

Collectives™ on Stack Overflow

Only Adding New Table Data in Excel vba

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related