Friday, 22 March 2013

How To Add a Workbook with Single Sheet

Excel VBA Macro To Add a Workbook with Single Sheet
Sub WbkWithSingleSheet()
Workbooks.Add(xlWBATWorksheet).SaveAs _
FileName:="C:\Documents and Settings\Administrator\My Documents\Sample", _
FileFormat:=xlOpenXMLWorkbookMacroEnabled
End Sub

'You can change your File Path which is colored above.
Thanks
Tamatam

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts