Re: give me a hand,thank you
It will all depend on whats in the document ie..Bitmaps,Tables etc.
If the Document is just text then thats no problem, if the document contains multiple objects then you have a problem.
Let me know whish it is and I'll tell you where to go from there.
Don't forget to rate!!!
Andrew Lennon (Berlitz)
Automation Dev Engineer
Re: give me a hand,thank you
The Document is just text.Thank you!!
Re: give me a hand,thank you
This code will open a specified Document (invisible) and loop through the activedocument to rebuild a single string for text (szwrd).
When adding this string to the database value should be a Memo Value so it's big enough to hold the string.
Dim wrd as Object
Dim szwrd as string
Dim i as Integer
i = 1
set wrd = CreateObject("Word.Application")
wrd.Visible = false
wrd.Documents.Open "C:\Temp.doc"
for i = i to wrd.ActiveDocument.Paragraphs.Count
szwrd = szwrd & wrd.ActiveDocument.Paragraphs(i).Range.Text
next i
set wrd = nothing
'ADD THIS string to YOUR DATABASE ----
'szwrd
Andy
Don't forget to rate Dude!!!
Andrew Lennon (Berlitz)
Automation Dev Engineer