Search results for query: *

Hi A programmer kindly wrote this code for me. However, I keep getting this error Microsoft Excel is waiting for another application to complete an OLE I stepped throught the procedure and find it happens at this point: With WordApp.Documents.Open(Filename:="C:\Documents and...

Thx again, Skip.

Thx Skip. That worked a treat. However, if the document is massive i.e. over 100 pages, the process might hang. IS there another way to do it?

Hi, I am trying to automate Copying all of a word doc to an excel sheet. Also, how do you check if word doc is open already and close it. I know you;d probably use a for ..next loop. Sub copy_word_2_xl() Dim WordApp As Object 'Open Word Set WordApp =...

Hi What I want to do is change Lecture to LECTURE. What do I need to modify the macro below. However, I only want to do this when Lecture is the only word on a line NOT when it is part of a sentence. e.g. Change all instances of Lecture to LECTURE when line is : Lecture and NOT: A...

Thank you for all your help. Helped so much and just what I needed.

Hi, I'm trying to look for s apecific word in a document in this case, l. And change all occurrences to lecture. However, if I use the macro below, it will change words like roll. to rolLecture which is not what I want. I only want to see words like l. and change them to Lecture. Hope...