UiPath macro formula change

  1. Business will provide an excel sheet in a shared path.
  2. Th excel will have an in built macro function.
    The bot needs to change a file path in that in-built macro function.
    how to achieve this ?

Write the macro to pull the path from a cell.