I've got a large excel model and I start off by importing the data from a csv file via VBA. As some of my data has leading 0's that I don't want to lose and I need to retain the formatting on certain fields, I've used power query and VBA to come up with the following code that imports my data...