help with cfobjects / excel pl .... ;-(

[CF5IISVB]

greetings:
am trying a simple piece of code from cfcomet.com, where using the cfobject tag , creating a excel com object to transport data from sql to excel.
the cfobject instantiates the excel object properly, but the code bombs when it has to actually write the data into the cell - it say " Cannot access read-only document 'xxx.xls'."

any help is much appreciated.
-r

 

[iqof188]

Make sure the xls-file is NOT read-only, and also make sure that the sheet is not protected. Hope this helps...


<webguru>iqof188</webguru>