0 Replies Latest reply: Nov 8, 2011 6:44 PM by Debbie Pyykkonen RSS

    Macro to Copy value to Excel Cell not working

      I am a novice at VBScript and am trying to get my macro for excel export to copy a value into a specific worksheet already named "About" and paste in the value of the variable "Report Group" but I cannot seem to figure it out.  This does not work but also does not give me an error.  Any help would be appreciated.  objExcelDoc.Sheets("About").Select  objExcelDoc.Sheets("About").Range("B1") = ReportGroup