I'm looking to create a macro that i can say look inside this folder and within each file found copy and paste a specific cell to a currently open workbook i have.
I need the macro to paste the cell below the previous.
The files that are being used are xml and so they need to be imported via the xml parser in order to copy information.
The folder can either be static or the user has to select it. (doesn't really matter which way)
To confirm the macro should loop through each file in a folder, open it via xml parser select and copy a cell to which it pastes inside a separate workbook i have open within column A for example but below the previous.
Once all files have been looped through the macro should finish. (Note: the macro shouldn't keep any unneeded files open once the information has been extracted.)
I need the macro to paste the cell below the previous.
The files that are being used are xml and so they need to be imported via the xml parser in order to copy information.
The folder can either be static or the user has to select it. (doesn't really matter which way)
To confirm the macro should loop through each file in a folder, open it via xml parser select and copy a cell to which it pastes inside a separate workbook i have open within column A for example but below the previous.
Once all files have been looped through the macro should finish. (Note: the macro shouldn't keep any unneeded files open once the information has been extracted.)
