Real-time txt to

Question

Dear sir Mondal, Hallo! I have a weighing scale linked to my PC. The scale sends weighing data to a txt file (*.txt).I would like to see these data being updated in a real-time manner (!) in anspreadsheat. When I try to import data while the scale is sending data to the txt file,"says" that it is impossible because archive is under use. It would be perfect to download these data as numbers (not as txt), in order to automatically construct charts with Excel. Could you help me with suggestions? I am not an expert and I do not know VB. Many

Answer

Please refer this link

http://en.allexperts.com/q/Excel-1059/Importing-Text-Files-Excel.htm

To learn basic VBA follow this nice link:

http://functionx.com/vbaexcel/

In the mean time please explain in detail, hows your data look like.

Ariful