Creating M-file using Excel/Visual Basic

I have a few Excel files which have a number of graphs and plots. I would like to now convert numeric data within these Excel files into a M-file and then load it within MATLAB.

I would like to automate this process such that at press of a button I can generate an M file.

Is there an existing plugin within Excel or some existing Visual Basic code that can do this?

I have absolute no knowledge of Visual Basic however if there is an example then I can probably suit it to my needs.

Any help or starting point or example would be appreciated.

Answer 1

[John]

Do you have to use visual basic? In MATLAB you can use xlsread to load in the excel file and then save the loaded data into .mat files.