We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
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
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Adding/Copying a field from one table to another (with properties)||11||42|
|MS Access How can I add a relative path to my VBA PDF output that will work for most Windows computers?||4||30|
|Having 'UserName' as a field name - seems to be causing issues||9||28|
how to predefine file name on Application.FileDialog(mso