This Excel VBA tutorial explains how to create a new workbook using VBA Code. You can also learn how to create new workbook and name it at a specific location.
Excellent Sir and So easy method to create workbooks..but Sir shall I know why you use SET Keyword along with wb what is the use of it and when we have to use it or when not.. if you could answer...
Private Sub CommandButton1_Click() Dim wb As Workbook Set wb = Workbooks.Add Application.DisplayAlerts = False wb.SavesAs Filename:="C:\User\\Desktop\\,FileFormat:=51 'xlsx=51 'xlsm=52 Application.DisplayAlerts = True ActiveWorkbook.Close ThisWorkbook.Worksheets("Sheet1").Cells(1, 1).Select End Sub
excellent video
Nice example. Thanks
Excellent Sir and So easy method to create workbooks..but Sir shall I know why you use SET Keyword along with wb what is the use of it and when we have to use it or when not..
if you could answer...
Great 👍🏽
Nice work keep it up
thank sir
every day file willbe change
Thank you so much bro, but I need create excell with data. Could you please do the video on that
Thank you Sir so muchhhhhhh;)
Most welcome
Thank you so mutch,Sir.
Most welcome
Sir how can we create lot numbers and expiry dates for one item with new lot numbers
Please share the looping statement to create multiple Excel file
Private Sub CommandButton1_Click()
Dim wb As Workbook
Set wb = Workbooks.Add
Application.DisplayAlerts = False
wb.SavesAs Filename:="C:\User\\Desktop\\,FileFormat:=51
'xlsx=51
'xlsm=52
Application.DisplayAlerts = True
ActiveWorkbook.Close
ThisWorkbook.Worksheets("Sheet1").Cells(1, 1).Select
End Sub
sir how can Saerch xyz workbook to abc workbook worksheet Name
plz Create video this problem sir