Setting up data connection to a network folder

[twofooted]

Hi All,

I have an instrument at work that creates a new .txt file every time it is run and saves it to a specific network folder. I want to create a connection to the folder so that when I refresh the connection it automatically imports any .txt file that hasn't already been imported into the workbook. Any good way of getting this done?

Thanks!

[GeneralDisarray]

Yes.. can you give a little more information?

Where are the contents of the text file being imported to - same sheet, new sheet?

Basic Sub to connect to network location:

Please Login or Register  to view this content.

Edit: fixed typo

[twofooted]

Great I will try this out. I want them to go to the same sheet if possible but it may end up being more organized to put them on separate sheets.