ronanbaker1
Board Regular
- Joined
- Nov 15, 2012
- Messages
- 76
Hi Guys,
I have an excel file opened. I also have 2 word documents opened (Word Document name changes). I want to create a macro in excel that will copy a page that has a particular word in it (Say word is called "Business"). There may be more than one page and if so it will paste each page in a new tab on my excel sheet.
for the pasting part I would like it to be an image.
ActiveSheet.PasteSpecial Format:="Microsoft Office Word Document Object", _
Link:=False, DisplayAsIcon:=False
My thinking towards this would be firstly activity all word files that are opened. Then use a Search/Find tool for every occasion it is found copy the page..... Can this be done?
I have an excel file opened. I also have 2 word documents opened (Word Document name changes). I want to create a macro in excel that will copy a page that has a particular word in it (Say word is called "Business"). There may be more than one page and if so it will paste each page in a new tab on my excel sheet.
for the pasting part I would like it to be an image.
ActiveSheet.PasteSpecial Format:="Microsoft Office Word Document Object", _
Link:=False, DisplayAsIcon:=False
My thinking towards this would be firstly activity all word files that are opened. Then use a Search/Find tool for every occasion it is found copy the page..... Can this be done?