General discussion

Locked

Linking Excel Worksheets to ASCII File

By RPB ·
Is it possible to link an Excel sheet to an ASCII file (let's say on the same drive, but different locations) and when the ASCII file is changed or updated have the linked Excel worksheet automatically updated with the changes? If so can you explain to me how to do it.

This conversation is currently closed to new comments.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Linking Excel Worksheets to ASCII File

by Peyison In reply to Linking Excel Worksheets ...

Does the ASCII file contain data that links to one cell, or many cells? What is the format of the ASCII file - is it like an ini file? (e.g. Key=Value)

This can be done with a custom function in VBA. Let me know if you're interested in more info.mike@peyison.com

Collapse -

Linking Excel Worksheets to ASCII File

by RPB In reply to Linking Excel Worksheets ...

Poster rated this answer

Collapse -

Linking Excel Worksheets to ASCII File

by Lo In reply to Linking Excel Worksheets ...

Hi - Not sure what you are actually trying to do here and if your terms are correct or if I even understand the question. Given that ...

Never having done this, I did a quick test. If you Insert, Object, Create from File (browse to the file), Check the Link to file box, you get an object that is a link to the file. If you double click the object you get the associated application NotePad for .TXT, etc. If the file is changed outside Excel, next time you double click the object you will see changes. I tested this with an editor. What you see is just a text file.

I would guess that isn't what you want. Normally (at least for me), an ASCII file is opened and 'imported' to Excel, munged and saved as an Excel Document. If you are looking for a 'faster, less error prone' process, Answer 1 is at least on the right track. You can probably do the import process (get an ACII file into Excel format) with a Macro (Tools, Macro, ...). Lo

Collapse -

Linking Excel Worksheets to ASCII File

by RPB In reply to Linking Excel Worksheets ...

Poster rated this answer

Collapse -

Linking Excel Worksheets to ASCII File

by RPB In reply to Linking Excel Worksheets ...

This question was closed by the author

Back to Software Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums