Logo 
Search:

VB.Net Forum

Ask Question   UnAnswered
Home » Forum » VB.Net       RSS Feeds

help vba

  Asked By: Dale    Date: May 29    Category: VB.Net    Views: 1347
  

trying to save and close file, please help getting error 1004 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("A4")
Filename2 = ("B4")
ActiveWorkbook.Saveas (Path) & (Filename1) & (Filename2)
ActiveWorkbook.Close
End Sub

Share: 

 

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

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




Tagged: