how can i make my output file name exported from excel (using a macro) be named after a field in the excel sheet itself?
i.e. the value from B1 from sheet 1
strDefFolder = Trim(InputBox(" Enter path to save file", "File Location", ""))
system = field B1
strFileName = system & Day
All help will do