Hi all,
i am new to VBA, but wanting to automate a manual process.
I have two folders locations (file paths set within two respective cells). I want the macro to look within both folders and combine (PLTs - text files) within the current sheet.
I have this Macro presently, which is looking at the first folder (C5), then following onto the next (C6). However, when I press run, the second Macro (irrespective of configuration) doesn't work. I think it may have something to do with defining the Path, but have tried various variables. Can someone please help?
The end goal is to integrate more folder lookups within the Macro, but just limiting it to two at the moment - so any help around this is appreciated.
Bookmarks