Taking the easy way out and asking you smart peeps :-)
I have a variable in VBA called "filename"
The filename value will be something like "Bob blah blah 10.15.xlsm"... But it might be a .xls file, either way the file extension is already part of the variable.
What i want is to save as filename (without extenstion) & "More Words Here" & filename (only the original extension)
Microsoft ExcelMicrosoft OfficeVisual Basic ClassicVBA