VBA Function to extract a value from closed CSSV file

[TheCrowl]

Hi All,

I'm a beginner to VBA and I'm trying to write a function to extract a cell value from a closed csv file. Ideally I want to extract the value from the last modified csv file in a folder.

Any help would be greatly appreciated.

[macropod]

You will need to open the csv file, but that doesn't mean loading it into Excel - you can use vba to simply open it as a text file and process it as such.