I've a word document with excel object. The cell b1 is set to import data from a text file. How can I get this cell to import data automatically when the word document opens without any user interaction?

Thanks!