how to search all word documents for text

'Set ws = ActiveSheet ' currently opened sheet on currently opened. MsgBox 'Copied value equals ' & Rng.Value & ' Roesler conquers.' 'Set WordDoc = WordApp.ActiveDocument 'I don't know how to finish this line :-( This is the above mentioned code amended by me to my best abilities.

activesheet (because the name of the excel file and excel sheet will change many times a day).īut the destination cell will always be E27 - it will never change. When I have this number (the price) in my clipboard, I need to paste it into currently opened excel file, into. Then I need to strip the number from this ridiculous dot in the middle of the amount, so please help me clear 605.000 into 60500 or 1.250.000 into 1250000. Set ws = ActiveSheet 'currently opened sheet on currently opened.xlsm file MsgBox 'Price is ' & ApartmentPrice & ' pln.' 'Please don't remove my question again - I've researched 16h for this info. 'I don't know how to write this part of the code. 'Set WordDoc = WordApp.ActiveDocument 'I don't know how to finish this line 1.Open a blank document, and then click Review > Compare > Compare, see screenshot. If you are familiar with the Word application, the Compare feature in Word can do you a favor, please do with the following step by step. Set WordApp = GetObject(, 'Word.Application') Quickly compare two Word documents and highlight differences. 'Reference already opened Word document from excel VBA console 'Set WordApp = CreateObject('Word.Application') Yes - only the amount of money without decimal values, because they're always ,00.īut not only seven signs, because if I had apartment price 1.250.000 then the macro that copies only 7 signs wouldn't work. The selected text occurs only once in the whole document therefore I need VBA to copy what's after 'brutto w kwocie ' and up to the first coma. The word file is a place where I learn what the price is. But I don't know the price before I check it in the word file. This picture shows the part of the document from where I copy the price. I'd like U to help me automate this task. docx file opened at the time on computer, so we just need to find the price in currently opened word file. What I'm doing until now, is I manually copy a price from the word document, which I previously open, and paste it into an Excel sheet.

How to search all word documents for text