Macro issue

Question

Hi,
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.

\hkgclhctx\home$\wong.peter

Answer 1

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