Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TO MODIFY A EXCEL OBJECT FROM WORD USING VBA
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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TO MODIFY A EXCEL OBJECT FROM WORD USING VBA
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 "Sandra Bonilla" wrote in message ... 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel object linked to word will not add sums in word | Excel Discussion (Misc queries) | |||
PLS HELP! Excel imbedded object in Word | Excel Discussion (Misc queries) | |||
Print Word Object in Excel | Excel Discussion (Misc queries) | |||
How to fix a Excel corrupt object pasted into Word? | Excel Worksheet Functions | |||
i am unable to add, delete or modify in excel or word. | Setting up and Configuration of Excel |