Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Importing / Linking / October 2005

Tip: Looking for answers? Try searching our database.

How to transfer info automatically from an excel data base to a word document OR an excel document?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Starriol - 31 Oct 2005 18:43 GMT
Hello

I'm working on a project with an excel database and need help with the
following.

This database has some dates that are changed regularly and I need to
make an automated
system so that everytime one of the dates is changed on the Excel
database, it changes automaticaly the date in 2 different word
documents and print them both.
Any ideas on how it can be done?

In the case you don't know how to do it on a Word document, I can get
one of the documents inside the database, the others (they are too
many) can be reformated to Excel files, but as external files, that is,
not in the same file of the database.

Thank you very much for taking your time to read this.

By the way, if your solution can be done without programming, much
better, I don't know of any programming language.
But if you can't think of a way to do it without programming, tell me
anyway and I see if I can get one of my more nerdy friends to do it for
me.
Thanks again.
Klatuu - 31 Oct 2005 19:16 GMT
This news group is about Microsoft Access.  If you need help with Excel, I
suggest you post your question in an Excel News Group.

> Hello
>
[quoted text clipped - 21 lines]
> me.
> Thanks again.
John Nurick - 31 Oct 2005 21:14 GMT
Do you mean an Access database or an Excel database?

If the former, you can create queries in the database that return just
the dates you need, and use Word's Database fields to display them in
the Word documents.

If the latter, normally one can just copy an Excel cell and use Paste
Special in Word to paste its contents into the document as a link which
will be automatically updated.

There's lots of good Word information at http://word.mvps.org.

>Hello
>
[quoted text clipped - 21 lines]
>me.
>Thanks again.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.