VBA - csv file import

Hi,

I am very new to VBA (having only really used the record function before) and am working through the training resources.

In the meantime I have a project where I am trying to achieve the following

- Import the second most recent csv file in a folder into 'Sheet 1' making sure the first column imports as text.

- Import the most recent csv file in the same folder into 'Sheet 2' making sure the seventh column imports as text.

(both of the above are delimited by comma)

I know this should be possible but after looking on various forums can't seem to get it to work correctly.

I can get a specific file to import or a loop of files from a folder but this still leaves me with an issue with the correct columns not being formatted as text (there are often leading zeros in some of the data which I need to keep which is why this is required).

Any assistance greatly appreciated!

Thank you

Hi Leith,

Thanks for your reply.

They are both downloaded files that are unopened/edited so both modified and accessed dates are the same.

Sorry I should have put that in my original post!