Logo 
Search:

C Programming Forum

Ask Question   UnAnswered
Home » Forum » C Programming       RSS Feeds

vba for save and close

  Asked By: Dale    Date: May 28    Category: C Programming    Views: 1688
  

please help, trying to setup to save each individual new opened file as days or nights???? See below
thanks

A3 date(today)
A4 trying to put a dropdown option for days or nights



Private Sub CommandButton1_Click()
Dim Path As String
Dim Filename1 As String
Dim Filename2 As String
Path = "P:\595Geismar\EASTSIDE E-LOG TEST"
Filename1 = Range("A3")
Filename2 = Range("A4")
ActiveWorkbook.Saveas (Path & Filename1 & "-" & Filename2 & ".xls")
'"FileFormat"":=" = xlNormal
End Sub

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on vba for save and close Or get search suggestion and latest updates.




Tagged: