Can someone please post a code example of how to read from and write to particular cells in MS Excel documents? And does the excel report have an NC-only option like the basic reports do?
Incredible.Mr.Lucas With that output I would just create a macro that reads in the first value to find the cell assignment, then writes the next value to it. Repeat until EOF
{aircode}
open file
parse out the junk
do while not eof(1)
Input #1,MyCell,Value
if chr(mid(mycell,2,1))<65 then
MyCol=left(mycell,1)
myRow=mid(mycell,2,len(mycell)-1)
else
MyCol=left(mycell,2)
myRow=mid(mycell,3,len(mycell)-2)
end if
MyRange=Concatenate(Mycol,trim(str(MyRow))
range(myrange).select
selection.value=Myvalue
loop
