Hi Dave, I've done a bit of report creation and other manipulation of Excel
in WSH, let me know what you need to know (what  you're having trouble with)
and I'll try to post a relevant example.

Richard

Hi Richard,  Thank you for the reply... Here is what I am
trying to do and the following code.  I am copying the
contents of a web page and opening Excel locally.  I then
paste the contents of the web site into excel.  I can get
the contents into excel but it comes through with
hyperlinks etc.  I would like to add an additional
copy/paste but using the Paste Special function with
the "paste as formulas" parameter which would then remove
the hyperlinks and formatting.  I just can't get the
syntax and can't find any reference.

Here is my script:

    <SCRIPT language="JavaScript">
        function bringToExcel()
        {

         this.document.execCommand("SelectAll", false);
         this.document.execCommand("Copy", true);
         this.document.execCommand("UnSelect", false);

         // Start Excel and get application object.
         var oXL = new ActiveXObject("Excel.Application");
         oXL.Visible = true;

         // Get a new workbook.
         var oWB = oXL.Workbooks.Add();
         var oSheet = oWB.ActiveSheet;
         oSheet.Paste();
         oXL.Selection.Copy();
         oSheet.Paste();
         //  oXL.Selection.PasteSpecial
("xlFormulas,xlNone,False,False");  Can't get the syntaX!!
         oXL.Visible = true;
         oXL.UserControl = true;
         }
    </SCRIPT>
Thanks again
Dave

manipulation of Excel
having trouble with)

There's a lot of stuff at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnof...
ml/vsofficedev.asp

I think what you want for the syntax of PasteSpecial is this:
// first define xlPasteFormulas - the constant that is passed to the method:

var xlPasteFormulas = -4123

// I got that value by looking in the Excel Object browser
// from any XL worksheet Alt-F11 then in the VBA window, F2

// next use it to call PasteSpecial
// also, use false, not False, unless you
// have separately defined a variable
// like var False = false;

oXL.Selection.PasteSpecial(xlPasteFormulas, false, false);

Let me know if this doesn't work for you,
Richard