Hi,
I was using a code to automatically save my reports in my documents folder in their respective folder.
But it is not executing correctly for some reason. I guess it is because , it is not able read my document path.
I am using below line code in my code
' Get the path to your My Documents folder
strFolderpath=CreateObject("WScript.Shell").SpecialFolders(16)
Debug.Print strFolderpath
On Error Resume Next
Can any one suggest…is this number 16 is correct or how do I find out my document path.
Thanks
I was using a code to automatically save my reports in my documents folder in their respective folder.
But it is not executing correctly for some reason. I guess it is because , it is not able read my document path.
I am using below line code in my code
' Get the path to your My Documents folder
strFolderpath=CreateObject("WScript.Shell").SpecialFolders(16)
Debug.Print strFolderpath
On Error Resume Next
Can any one suggest…is this number 16 is correct or how do I find out my document path.
Thanks