Quote:
|
Query 1 - is there a way to have the macro read a "/" in either of the two referenced cells and convert it to a "_" in the file name but leave it as "/" in the cell?
|
use a variable equal to the cell value and manipulate the variable rather than the cell.
Something like
Code:
'
L5part = Sheets("Report template - Advanced").Range("L5").Value
L5part = Replace(Replace(L5part, " / ", "/"), "/", "_")
MsgBox L5part
'
Quote:
|
Query 2 - how, what, where have I gone wrong in the save routine.... and apologises for the longwinded ramble.
|
Sorry, I don't know.
06-10-2019, 07:16 AM
Similar Threads
Word 2007 Option buttons - transparency
Windows 7 64bit 
Office 2010 64bit
Threaded Mode