I have a CSV file named CSV_File.csv which is saved in the same location of my present Excel Workbook which contains a matrix of numbers of rows 100 and columns 1000.

I want to extract the value of the cell from 4th column and 5th row without opening it. The size of the file CSV_File.csventer code here is quite huge so I restrain from opening it.

I used below VBA code without success

MsgBox "=(" '[CSV_File.csv]Sheet1'!D5 " ;"") "

Could you please help with the right VBA code?

I also want to pass the row and column indices without the cell name i.e. instead of passing D5, I want to use the index number (5,4)

Any pointer will be very helpful.

Thanks for your time.