This is what I have so far in my Marco and it seems to work fine:
Private Sub Workbook_SaveAs()
ThisFile = Range("A1").Value
What I would like to do next to specify a file path save e.g. “c:\temp” and not sure how to add it into the VBA code above.
Also I would also like to run the above code every time the file is opened up. Note sure how one would do this with VBA code.
Any help would be gladly appreciated.