Vba

[peter_theo]

Please advise what is the problem with this line. It keeps giving an error and I can't understand the reason. I am newly playing with VBA automating some functions and commands in my excel sheets.
Thanking you in advance for any enlightenment given.

ActiveWorkbook.SaveAsFilename: = Path & FileName1 & "-" & FileName2 & "-" & FileName3 & ".xlsm", FileFormat:=xlNormal

 

[Rick Rothstein]

Please advise what is the problem with this line. It keeps giving an error and I can't understand the reason. I am newly playing with VBA automating some functions and commands in my excel sheets.
Thanking you in advance for any enlightenment given.

ActiveWorkbook.SaveAsFilename: = Path & FileName1 & "-" & FileName2 & "-" & FileName3 & ".xlsm", FileFormat:=xlNormal

It looks like you need a space between the "SaveAs" and "Filename"

 

[peter_theo]

It looks like you need a space between the "SaveAs" and "Filename"

Dear Rick many thanks for the response. Please see bellow the whole code and help me out as the SaveAs line is driving me nuts...

Private Sub CommandButton1_Click()
Dim Path As String
Dim FileName1 As String
Dim FileName2 As String
Dim FileName3 As String
Path = "C:\MarketsActions\"
FileName1 = Range("AA3") 'PeruActions
FileName2 = Range("AB3") 'Text(Todate(),"yyyymmdd")
FileName3 = Range("AC3") 'Text(Now(),"HHMMSS")
ActiveWorkbook.SaveAs Filename:=Path & FileName1 & "-" & FileName2 & "-" & FileName3 & ".xlsm", FileFormat:=52
End Sub

 

[Rick Rothstein]

Dear Rick many thanks for the response. Please see bellow the whole code and help me out as the SaveAs line is driving me nuts...

What is happening, or not happening, that is "driving you nuts"?

Are you getting an error message? If so, what is its number and description?

 

[peter_theo]

It Works Perfect now and not even sure why... The only thing I noticed is that I opened the excel file with another computer with also Office 2007, but and the Big But is that the button Save is not working. Why is that? Does the other user has to have VBA to run the micro?
Please advise. Thank you so much for all the help.