Please Help me find a better way instead of using a Macro

[Bryan1187]

Does anybody know how to sole the following problem:

I receive Excel files from customers in several different formats. Unfortunately, in order to work correctly my software program requires that all Excel files are in the same format. This requires manual labor and the use of a Macro to help reduce the amount of manual labor to make the conversion happen. My Manager wants to know if there is a plug-in, app, or a better way in general that would help us automatically convert all Excel files that we receive from customers into a standardized format automatically? Please help if you know a way to do this.

Thanks!

 

[ranman256]

No better way than a macro. In the email, run a macro,
it saves the attachment to a folder in the correct format,
then loads it into your program.
You don't want that?