TO MODIFY A EXCEL OBJECT FROM WORD USING VBA

  • Thread starter Thread starter Sandra Bonilla
  • Start date Start date
S

Sandra Bonilla

Hi,

I'm trying to modify several Excel objects in word. I need to open
every Excel object (one at time) and after that I need to find and
replace a text in it, save changes and return to word to go the next
until the last Excel object has been changed.

Unfortunately I have done it manually but I couldn't do using VBA and
there are 110 files waiting for this process.

I'd apreciate if any of you can give me an idea.

Thanks,

Sandra
 
Sandra,
As a start, go to Excel and record a macro of the step that you require.
You should then able be able to transfer this code to Word, with the
addition of you object reference to Excel.

NickHK
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems starting Word from Excel VBA 3
How to Pause an Excel VBA script without freezing excel 1
Word Document Object on excel Sheet 8
Tranfer data from Excel to word (Docx) via VBA in Excel 5
writing excel data into word document 1
Open a word mail-merge document from Excel VBA 1
Turning off Whole Word selection in Excel 2007 1
VB.NET with Excel VBA 3

Back
Top