Microweak (Microsoft) Excel
I prefere to write data files from my applications (e.g. LabView-Control programs or AspenPlus-Simulations) into Comma-Separated-Value-Files, so called CSV-files and if I work under
Microweak-Operating Systems like MS-Windows-XP, I like to investigate my data via MS-Excel.
To avoid that the file is blocked for other applications I open the CSV-files in the
read only mode and here I had problems to update the file through a script, I found no help, so
I hope the following VBA (Visual Basic for Applications)-code is also of value for others.
Refresh Read Only opened CVS-Files in MS-Excel
Up:
Home: Start
V.i.S.d.P.: Stefan Pofahl, 89075 Ulm, Germany