Multiple excel files and use of VBA

Hi Stephen

Thanks for getting in touch. That is completely possible and is just one method of doing this. It will depend how much of the data you wish to manipulate and how variable the size and location of the data is.

If the data is in the same place and you are drawing data together as opposed to modifying it greatly, perhaps VLOOKUPs will be enough?

There isn't "one size fits all". But if you're going to work with other files, look up the OPEN, DIR and NAME commands in VBA help. Respectively, these open workbooks, gets the filepath as a string, and renames a workbook.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector