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

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



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.