I am still looking on how to do this.... I really need help with the Macro that would be written to save my excel that it automatically save into the assign SharePoint location.