Thread: [Solved] Falling at the last hurdle with Checkboxes and Option buttons
View Single Post
 
Old 06-10-2019, 07:16 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
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.
Reply With Quote