Hi,

I'm trying to do some automation of Excel through Jscript, but I keep getting an error in regards to when I try to pastespecial (PasteSpecial method of Range class failed). Any help would be great...

<script type="text/javascript">
var objXl, ws;
function test()
{
    objXl = new ActiveXObject("Excel.Application");
    objXl.Visible = true; //set to TRUE for debugging
    objXl.WorkBooks.open(document.forms[0].tFile.value);
    ws = objXl.ActiveSheet;

    var xlPasteValues = -4163;
    var xlPasteSpecialOperationNone = -4142;
    var xlPasteFormulas = -4123;
    var total = ws.UsedRange.Rows.Count;

    ws.Range("C2").value = "=concatenate(A2,\" \",B2)";
    ws.Range("C2").Copy();
    ws.Range("C2:C"+total).Select();
// ws.PasteSpecial(); <- works but copies the formula
// ws.PasteSpecial(xlPasteValues,xlPasteSpecialOperat ionNone,false,false); <- doesn't work, but this is what I need to work...
}
</script>

The code shown at http://p2p.wrox.com/topic.asp?TOPIC_ID=33665 seems to have a few minor differences to yours, suggest you try them out and let us know if it works.