Saving file in current directory after accessing file in another directory

Hi all,

New here, so cheers to all!

My problem is next: I need to open a excel sheet, run a macro (which I already have) that will open a new existing sheet in a always constant location on network, do some process on that sheet, and as a result create new file in the folder of original file, something like:

1. step: open \\some network folder\some file A, where file A and its location can be different each time
2. step: starting macro which opens \\determined network location\determined file B, where as it is said, file B is always the same and on same location
3. step: calculates whatever needed, creates new file some file C as a result, and
4. step: saves that some file C to a original opened file location - \\some network folder\some file A

Thanks!