Reading from an excel file into an array

[MarcW]

Hello,

I need to be able to select an excel SS and have each cells contents stored in an array for later access. I have the select file dialog working, just need to know what the best function is to capture each cells contents and store in an array index. What would be the best way to go about this?

Thank you all in advance!

[hawky358]

_ExcelReadSheetToArray() does exactly this

[MarcW]

Thank you, it does exactly what I needed!