An alternative is to use PHP libraries, such as PHPExcel and PHPExcelReader. Even though you said you have no knowledge of PHP, these libraries are written for you, so it's just a matter of specifying the file and using their functions (and they come with examples and documentation).
The last alternative is to make your life a bit easier in the long run and use a database. If it's not too large right now, you can migrate the information.
If you really want to use VBA for this, you can by converting everything to a .CSV and writing code to read it or use a library for it. Again, this depends exactly what you want the result to look like, its functionality, any other features, etc... .