Link .txt file for excel to update changes

Hello there,

Is there a way to import a .txt file with delimiters and have excel update automatically when the .txt file is updated externally?

Please let me know as that would be a HUUUGE help!

Thanks,
Lorne

Any help? Is this even possible?

Thanks
Lorne

Yes it is possible. You can get the delimited .txt file into Excel by using Data > Import External Data and connecting to your .txt file as a data source (don't use the Text Import Wizard). This will create a query table on a worksheet containing the data that can be refreshed at intervals from 1 to 60 minutes, without any VBA code.

To refresh the sheet when the .txt file changes, you could monitor that event with a VBScript file using either WMI or FileSystemObject (DateLastModified property of a file) to respond to the file change and refresh the query table.

Hello there,

Ok so I am using Excel 2007 and I went to the Data Tab>Get External Data, I tried originally the 'From Text' command, and that imported but didn't link.

Then I tried the from other sources>data connection Wizard and that didn't work. Then I went to the Data Tab>Connections Ribbon and added the .txt file into the connects, but then I can't get it to show up in the spreadsheet?

What am I missing? Is there a tutorial online somewhere? I can't seem to find anything.

Thanks,

Lorne

I'm still trying to get this linked .txt file figured out. Can anyone share some insight? Thanks,
Lorne