Jump to content


Photo

Creeaza si salveaza un nou fisier Excel folosind VBA


  • This topic is locked This topic is locked
No replies to this topic

#1
TRACK)(

TRACK)(

    V.I.P

  • Posts
    2,428
  • Topics
    152
  • Reputation
    1988
  • Online
    37 days
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.
 
Sub AddSaveAsNewWorkbook()
Dim Wk As Workbook
Set Wk = Workbooks.Add
Application.DisplayAlerts = False
Wk.SaveAs Filename:="C:\MyData\fisier_nou.xls"
End Sub

  • 0




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users