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", _
End Sub

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

No comments:

Post a Comment

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts