[AccessD] Access 2 Word

MartyConnelly martyconnelly at shaw.ca
Thu Sep 18 14:14:31 CDT 2003


Word 2000 doesn't have all the xml capabilities however
you can drive all this from access just read directory filenames into a 
table
Then scan through names open up word object from access vba and run the 
code to convert the file
from the word vba code, you can get this if you record the macro in word 
of the steps you take from the menus to create the file. Then add this 
word vba macro to your code.


Bob Heygood wrote:

>Marty thanks for responding.
>
>I can open each file and set an option and save as text and have comma delim
>files created.
>But I want to do this thru automation/code processing all files at once.
>Can Word 2000 do as you describe?
>
>TIA
>
>Bob
>
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of MartyConnelly
>Sent: Wednesday, September 17, 2003 2:29 PM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] Access 2 Word
>
>
>How about using Word203 to dump all the data to XML files,and using the
>WORD 2003 XSD schema file scan through the xml files by bringing them
>into an XMLdom and use Xpath to rip out the interesting bits.
>
>
>Bob Heygood wrote:
>
>  
>
>>Hello to the List,
>>
>>I am hoping to extract some data from more than 800 Word .dot & .docs. The
>>user has saved these without either naming the fields or inserting
>>bookmarks.
>>My thought is to iterate thru the Fields collection and capture the info. I
>>would welcome any help with the code to do so or another idea. I also have
>>considered using a search routine to find the location via the text
>>preceding each field.
>>
>>TIA
>>
>>Bob Heygood
>>
>>
>>
>>_______________________________________________
>>AccessD mailing list
>>AccessD at databaseadvisors.com
>>http://databaseadvisors.com/mailman/listinfo/accessd
>>Website: http://www.databaseadvisors.com
>>
>>
>>
>>    
>>
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>  
>




More information about the AccessD mailing list