Excel: error "Illegal characters in path."

[pjaiphak]

Hi All Developer,

 1.  I need to read and write this Excel file on web browser service.
 2.  File path Sample

https://websbbb.com/sites/Mysite/Shared%20Documents/TT/Product%20Movement%20Plan/Product%20Movement%202019.xlsx?web=1

 3. Assign directory Sample

Directory.GetFiles(“https://websbbb.com/sites/Mysite/Shared%20Documents/TT/Product%20Movement%20Plan/Product%20Movement%202019.xlsx?web=1”)

4. Error: Assign: Illegal characters in path.

Could you please help advise how to fix it.

Thank you in advance.

[Jersey_Practical_Sho (Jersey Practical Shooter “X X Sonic Loss Xx”)]

are you able to map the path to a drive assignment?

[pattyricarte (Patty Boy)]

Hi @pjaiphak
I have experienced this. what I did is to put another “//” in the path

https://websbbb.com//sites//Mysite//Shared%20Documents//TT//Product%20Movement%20Plan//Product%20Movement%202019.xlsx?web=1%201

cheers

Happy learning

[pjaiphak]

Hi @pattyricarte Thank you for advise. as i try still error.
i’m not sure activities excel application scope support file from https://xxxxx

Thanks.

[pjaiphak]

Hi @pattyricarte and @Jersey_Practical_Sho
As you advised. i has apply and solution as below.
1 Mapping drive from iShare.
2 Open folders and right click on excel file
3 Copy path
4 in excel application scope i paste file path and working fine.

Thanks.