Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Sub GenerateExcelSpreadsheet() ' Dim oXLApp As Object Dim oXLBook As Object Dim oXLSheet As Object Dim iOption As Integer Dim sWorkbookName As String Dim sOutputPath As String ' iOption = -4143 ' Or 56 ??? sWorkbookName = "TEST" sOutputPath = "C:\Trash\" & sWorkbookName ' Set oXLApp = CreateObject("Excel.Application") Set oXLBook = oXLApp.Workbooks.Add Set oXLSheet = oXLBook.Worksheets(1) ' With oXLApp ' ---- ' ----Populate the cells ' ---- End With ' oXLBook.SaveAs ---- Format:=iOption ' Set oXLApp = Nothing Set oXLBook = Nothing Set oXLSheet = Nothing ' End Sub
|Sending email from Excel 2016 VBA and Outlook 2016||4||35|
|VBA Overflow problem when filtering||14||37|
|Help adding more columns to my pivot table||19||20|
|Fix it so that it will not have end target date before start date.".||2||6|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
24 Experts available now in Live!