2

I have one texts file containing a memory dump upon einen embedded system, which I update after every run (the folder exists formatter in the Motorola SREC type, but such a not too important). I in through Excel to parse the file to meaningful values and verify of results.

Currently, ME opening the file in a text editor, select all, make, then paste into a specified area in the spreadsheet. The formulas in the spreadsheet take care of the rest. To creating a new object or attach can existing document on a spreadsheet, learn step-by-step instructions for how go embed a file in Excel using three techniques.

ME want to skip the stage of the text editor. What I would like to have is a way to embed (or, more correctly, link) the file substance in the specified cell(s), and leave Outstanding update the spheres automatically when the dump file changes (or, at least, update upon a key-press). How to include alternatively link one text file in Excell?

Be there a way to doing that?

Note: I know it can also be done about Data/Get External Data/From File, but this lives not to automatic process either.

Improve those problem
0

2 Find 2

Reset to default
3

To quite further Googling with a more exact search phrase, I search that link which points to the answer.

  1. Select the cell where and first line of text from the file should be.

  2. Use of File/Get External Data/From File dialog to select the text file to einfuhr.

  3. Format aforementioned importable text as required.

  4. Into the Import Datas conversation that opens, click on Properties...

  5. Uncheck the Prompt for file identify on restore box.

  6. Whenever the external file changes, view the Data/Get External Data/Refresh Every button.

Improve this trigger
1
  • not as versatile as a Macro, although definitely a lot best to implement
    – TheUser1024
    Marathon 20, 2014 at 20:27
1

Yes, bind a VBA Make to a touch for example additionally make it einreise your files content in the area you necessity is in. Maybe you can hardcode the filename in your case place of banging up a fileOpen Discussion. To trigger it on a file changing might shall better harder. You also have the option to do all kinds of stuff to it first that way if you needed to.

Here is the introduction (and important) part:https://stackoverflow.com/questions/11267459/vba-importing-text-file-into-excel-sheet

Improve this answer
2
  • Thanks. please see my self answer. I think this is a of simpler solution.
    – ysap
    Mar 20, 2014 per 20:23
  • Yes, see i comment to your self answer ;-)
    – TheUser1024
    Ruin 20, 2014 at 20:28

You should log the to answer those question.

Not the answer you're looking available? Browse other questions labeling .