Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 133
  • Last Modified:

Link one application to another application

I can't seem to find how to run a function that collects information from one application (Excel) and pastes it into another application (Word) and then repeats the process until all the data has been transferred from Excel to Word.  I need something more than just to link or embed the information since the information in excel will be constantly changed with new files that need copied to Word.  
Any ideas???
Any information you could provide me would be GREATLY appreciated.
0
dderocco
Asked:
dderocco
  • 4
  • 2
1 Solution
 
VBGuruCommented:
you can write an application which automates both word and excel. First use copy fuction for excel and then use paste in the word document. if you are interested with the ideal let me know.
0
 
dderoccoAuthor Commented:
VBGuru...
definetly interested.  Can you tell me more??

drew
0
 
idcanadaCommented:

Reference the Word 8 or 7 object in your project.
Now you should be able to see the available options.
Such as
Dim objWord as new (Select the Word.Basic Object)
objWord.(List all the options)


0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
VBGuruCommented:
I will get you the sample code to work. give me some time
0
 
VBGuruCommented:
You can use macro editor if you don't know which object to use to access the functionality.
First create a macro(record it automatically) in excel the work of selecting and copying the content. you will get a macro for that.
Once again create a macro in word to paste the content and save it.
Now you got almost full source code to use OLE automation. modify the source code to suite VB. And that will work fine.
If you face any problem in between let me know.
0
 
dderoccoAuthor Commented:
VBguru...
Can you provide more information?  I'm having trouble writing the code to start and execute the macros for word and excel.

thanx
0
 
VBGuruCommented:
Open the word application and in the tools menu oiptios you have macro option.Try it out writing a macro.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now