Macro issue

Peter_1985 1,891 Reputation points

The following is version of Excel macro
I do not know why Application.ActiveWorkbook.Path is not having path of Excel file which is being stored on Sharepoint but it is having value below.


Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
2,172 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AddWebSolution 161 Reputation points

    Use Application.ActiveWorkbook.Path for just the path itself (without the workbook name) or
    Application.ActiveWorkbook.FullName for the path with the workbook name.