removing ‘ ‘ from varible in VBA (xls 2007)

Topic

New Reply

Hi loungers,

I am having an issue with saving my workbook because the save name is getting ” put before the name and after because of how I am declaring the varible txtSaveName does anyone have a solution for this?

my code is below

Sub SaveProposal()

Dim LastSaved
Dim txtSaveName

LastSaved = Range(“LastSaved”).Value

If LastSaved = “” Then
txtSaveName = Range(“txtSaveName”).Value
ActiveWorkbook.SaveAs Filename:= _
txtSaveName, _
FileFormat:=xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
Range(“LastSaved”).Value = Now()
Else

ActiveWorkbook.Save
Range(“LastSaved”).Value = Now()
End If
End Sub

Reply | Quote

Replies

Does it work better if you use

txtSaveName = Format(Range(“txtSaveName”), “yyyymmdd hhnnss”)

Reply | Quote

no for some reason when I goto the directory the file type in unreconized, when I goto Properties the name has “savename”

Reply | Quote

You should add an extension to the file name.
Can you explain what your code is supposed to do and what the ranges mentioned in the code contain?

Reply | Quote