[BlackBeltNow]

Lets say in B4 it says 104445. I want ot make a macro, which saves the excel file in a folder with the same value/string within a cell (i.e. B4), so if the macro works, it should save the current file as 104445.xls . A lot of coworkers are computer illiterate (they're old), and don't know how to save in the right directory

in general, my lab is disorganized. the label maker we have is just barely "sufficient". the label maker is unnencessaril difficult. it takes like 3 steps. my current (and done) method takes one. this seems to not be simple enough since the computer illiterates save the final file in the wrong directory. i want to make the save function automated. Our lab is a science lab, and it just takes too much time and energy making somethign so trivial like labels.

my current desperate solution is, when u click "save" it has a popup window and asks you to type the file name, and the macro will save using that file name u just typed into the right directory, but this is error prone cuz some ppl might type the wrong number there inadvertently, and save as the wrong file name.