Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

0 Replies