I am running an Access VBA routing that imports 150,000 CVs.
It uses something like
Dim stm as adodb.stream
.type = adTypeBinary
This works well but it Word stop the routine with the 'Convert File from:' (.txt, .rft, etc, etc) pop up quite regularly ... the annoying thing is that the default always works.
I was thinking perhaps I could use
but the Access code never hits that line, as it's waiting on the previous .LoadFromFile.
Is there anyway of stopping the Covert File popup, or a way of sending an ENTER keystroke or somethign ... i really don't want to have to sit here and watch this !