Hi,
I was wondering if anyone could advise on a VBA script that will do the following:
1) Loop through each word doc (.docx) in in folder path in Sheet1, A2
2) copy entire content of the doc
3) paste to sheet2, A1
4) pause for 2 seconds once pasted
One additional challenge, which is not as critical, is that the word docs have some text in textboxes. I would ideally like the VBA script to extract all the text from the textboxes and add them to the next empty row in column A of Sheet2.
Thank you!
I was wondering if anyone could advise on a VBA script that will do the following:
1) Loop through each word doc (.docx) in in folder path in Sheet1, A2
2) copy entire content of the doc
3) paste to sheet2, A1
4) pause for 2 seconds once pasted
One additional challenge, which is not as critical, is that the word docs have some text in textboxes. I would ideally like the VBA script to extract all the text from the textboxes and add them to the next empty row in column A of Sheet2.
Thank you!
