Q:

saving a file to dynamic path which is a value in excell cell

I have a vba code in PowerPoint which saves the file automatically with a Name of the Excel file which is active .
 PowerPointApp.ActivePresentation.SaveAs "Z:\05_PROJECT\Tanverdi\" & Replace(ThisWorkbook.Name, "xlsm", "ppt"), 1

Different People are going to use this macro and they all have different Folders that they save it, so i want the path of the Folder to be dynamic too. Best would be getting the path Name from my active excell cell, they can write the path Name in Excel cell and i can use this cell value as a path. 
But how do i do this ?

A:

Let's say the path is in Sheet1/Cell A1, replace your hard coded path with:
PowerPointApp.ActivePresentation.SaveAs ThisWorkbook.Sheets(1).Range("A1").Value & Replace(ThisWorkbook.Name, "xlsm", "ppt"), 1

