Excel Auto Import

[DannyBill]

Does anyone know how to get excel to automatically import a text file. I've set the refresh option in the external data properties, but when it refreshes, I'm required to click on the import button. I want it to do this automatically.

Thanks in advance for any help.

Dan

 

[SkipVought]

Hi,

Check the Data/Get External data/Data Range Properties for the Refresh on open checkbox.

Skip,

_{[red]Be Advised![/red] For those this winter, caught in Arctic-like calamity, be consoled...
Many are cold, but few are frozen!}