Say, I wish to save the excel file with VBA code and use the contents of 2 cell for part of the file name.
I also need to check if the specified directory is available before saving as its a remote location and not always available. If not available msgbox to prompt user to see why not available
filename: "Site Sheet" & Sheet"Raw" Cell A1 & " " & Sheet"Raw" Cell A2
To be saved as .xls file