 |  |  |  |  |  |  |  |
How to automate some interaction between "Word" and "Access" documents?
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
On my desktop I have one “Word” document and one “Access” document. Each one contains a macro. I want firstly to open my “Word” document and run the macro in it, and then right after that I want the “Access” document to open automatically and run its macro. How can I automate this whole process? Some people told me I need to use Office Automation, but I don’t know how.
•
•
Join Date: Aug 2005
Posts: 15,484
Reputation: 
Solved Threads: 1478
Search MSDN and google for "Office Automation". You will probably have to write a VB Script to do that -- note that is not the same thing as a VB program. You could use c++ also, but it will be about 100 times more difficult and complicated.
Last edited by Ancient Dragon; Dec 13th, 2006 at 7:03 pm.
Don't PM me with questions -- you might get a nasty PM in response. If you have a question then post it in one of the forums.
|
Similar Threads
- From "Word" to "Access" automatically (MS Access and FileMaker Pro)
- google "keyword" question (Search Engine Optimization)
- Google results penalty from using the word "victim" (rock band link) (Search Engine Optimization)
- No "insert page numbers" in MS Word (Mac Software)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Ten minute timer ???
- Next Thread: Connecting to web server using client desktop application
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
* 6 429 2007 access activex add age append application arrays basic beginner birth bmp calculator cd cells.find click client code college column component connection connectionproblemusingvb6usingoledb copy creat ctrl+f data database datareport date delete dissertations dissertationthesis dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver structures subroutine table tags textbox time urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
