Macro issue

Peter_1985 2,586 Reputation points
2021-06-22T03:49:07.38+00:00

Hi,
The following is version of Excel macro
107987-1a.png
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.

\hkgclhctx\home$\wong.peter

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
    2021-06-22T06:14:04.597+00:00

    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