World of Metin

Creeaza si salveaza un nou fisier Excel folosind VBA

View previous topic View next topic Go down

Creeaza si salveaza un nou fisier Excel folosind VBA

Post by Bogdan on Sun Sep 22, 2013 8:38 am

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



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

Bogdan
Membru
Membru

Posts : 50
Reputation : 0
Join date : 22/09/2013

View user profile

Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum