Ok I've got an excel macro that controls a word form processing. I need this to do a saveas but I need the path to be sort of dynamic.
Is there a way to get VBA to select the save as location dependant on certain charicters in a file path?
basically we have \\server\documents\sites\000 site name\communications\
where 000 is the unique site id, we want this location to be able to be put into the saveas command based on just this info.... I know this isn't reading very very clear, but i can't think how else to phrase ita t the moment. the Saveas script is below
Is there a way to get VBA to select the save as location dependant on certain charicters in a file path?
basically we have \\server\documents\sites\000 site name\communications\
where 000 is the unique site id, we want this location to be able to be put into the saveas command based on just this info.... I know this isn't reading very very clear, but i can't think how else to phrase ita t the moment. the Saveas script is below
Code:
Set SaveAsName = ThisWorkbook.Path & "\" & SiteName & " - " & Company & ".doc"
.ActiveDocument.SaveAs Filename:=SaveAsName