asked on Excel VBA Save as
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)
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
Last Comment
Saurabh Singh Teotia
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Works perfect!
I converted it to one long string to use as the filename to save an updated copy of an exisiting/open file.
I converted it to one long string to use as the filename to save an updated copy of an exisiting/open file.
Left(filename, InStrRev(filename, ".", -1) - 1) & " - NEW ADDITION TO FILE NAME" & Right(filename, (Len(filename) - InStrRev(filename, ".", -1)) + 1)
ASKER
Delivering excellent results, as usual!
Thanks Ray.. Always happy to help.. :-)
Saurabh...
Saurabh...
Trying this today and bet it works!