Macro issue

Peter_1985 2,586 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.
3,641 questions
0 comments 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.

    0 comments No comments