Cum sa creezi foarte simplu un nou Workbook Excel folosind Visual Basic for Applications

Nimic mai simplu.
Copiati codul de mai jos in VBA in Excel si customizati calea noului fisiere din penultima linie de cod.
Bafta


Sub AddSaveAsNewWorkbook()
Dim Wk As Workbook
Set Wk = Workbooks.Add
Application.DisplayAlerts = False
Wk.SaveAs Filename:="C:\MyData\fisier_nou.xls"
End Sub

1 Comment
  1. maramicuip 11 years ago

    excel rules!

Leave a reply

Your email address will not be published.

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.

©2024 KLEO Template a premium and multipurpose theme from Seventh Queen

Log in with your credentials

Forgot your details?