Parsing with VBA - best available toolset?

[andydtaylor]

Hi,

I have a need for a parsing and data cleansing toolset for use with Excel files.

I've done a lot of this ad-hoc recently with project and ledger data in an array of formats. e.g. time series split accross columns/tabs/workbooks, 1/2 colums per sheet, data is line broken in an odd manner, Data cumulative versus incremental, cumulative with January reset etc etc.

I'd like to find out if these is something already out there where months of debugging has already been done. I'd be interested in code snippets/paid-for/free tool bars, gitbub repos etc.

Thanks,

Andy

 

[RedBeard]

There's a list of stuff here, plus tools at the end: https://support.office.com/en-us/ar...our-data-a64879eb-115f-4e3d-a3bf-9cfc08a0a4e3