Hi, complete amateur with no experience of VBA and with no internal IT resource!
I receive a number of statements in txt format from a broker daily with various cash and stock balances and I would like the ability to convert en masse into a spreadsheet. I cant use power query as the files arent all structured the same way as they contacin different columns from each other.
Therefore is there a way I can a) take the files from the email (they are sent with the same title and yesterdays date) and b) convert them all into one workbook?
Thanks
M
I receive a number of statements in txt format from a broker daily with various cash and stock balances and I would like the ability to convert en masse into a spreadsheet. I cant use power query as the files arent all structured the same way as they contacin different columns from each other.
Therefore is there a way I can a) take the files from the email (they are sent with the same title and yesterdays date) and b) convert them all into one workbook?
Thanks
M