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 sSQL As String Dim objXL As Object Dim objWB As Object Dim sFile As String Dim sShtName As String Dim i As Integer 'Set name of file to save to sFile = "C:\ANOMALIES.XLS" 'Set name of new sheet sShtName = "ANOMALIES" 'Create a new excel document Set objXL = CreateObject("Excel.Application") 'create new workbook Set objWB = objXL.Workbooks.Add 'Save as a new file, delete existing file if it exists If Dir$(sFile) <> "" Then Kill sFile objWB.SaveAs sFile objWB.Close objXL.Quit 'CLOSE DOWN Set objWB = Nothing Set objXL = Nothing
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Excel 2007 Random Generate List Based on Defined Source Cells||3||29|
|EXCEL String-handling question ...||7||51|
|Excel to show a dynamic Picklist at level2||2||23|
|Excel - query for count of numbers in a range||8||14|
Join the community of 500,000 technology professionals and ask your questions.