I have a macro that saves the template as an xls. file based upon cell
contents. The location is also based upon another cell contents. The macro
works correctly....once. After that, the template utilizes the last
location|filename that the macro used as the current location and filename in
the macro button.
The macro looks like this:
sPath = Range("B8").Value
If Right(sPath, 1) < "\" Then sPath = sPath & "\"
ActiveWorkbook.SaveAs sPath & ActiveSheet.Range("B9").Value
I am attempting to reset the macro prior to it running by using the "assign
macro" and "macro name" on the toolbar(macro button). I think I need to use
"MsoCommandBarPopup." command to accomplish this, but I can't get it to
work!( or maybe find a way to keep this from happening!) I am new to visual
basic and learning fast..... maybe not fast enough!
Thanks for your help.
Tim