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.

https://answers.microsoft.com/en-us/msoffice/forum/all/macro-dynamically-use-file-paths-stored-in-cells/41f02f0e-4407-4e0a-8045-0f65e423dd47