New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
Dim objXL As Object Dim objWB As Object Dim strReportName As String strReportTitle = "Report Name" 'Create a new excel document Set objXL = CreateObject("Excel.Application") 'To create new workbook Set objWB = objXL.Workbooks.Add 'This now creates the error. With or without parenthesis () at the end. objWB.Sheets(1).Name = strReportName
Join the community of 500,000 technology professionals and ask your questions.