Problème d'accès à un Excel partagé via vba Outlook

%3CLINGO-SUB%20id%3D%22lingo-sub-3480911%22%20slang%3D%22fr-FR%22%3EProblem%20accessing%20a%20shared%20Excel%20through%20vba%20Outlook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3480911%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EI'm%20trying%20to%20open%20a%20shared%20excel%20file%20(on%20a%20sharepoint)%20from%20an%20Outlook%20VBA%20macro.%3C%2FP%3E%3CP%3EWhen%20I%20indicate%20the%20following%20url%20%22%3CA%20href%3D%22https%3A%2F%2Fgroupsg001.sharepoint.com%2Fsites%2FFTClients%2FShared%2520Documents%2Ffichier.xlsx%3Fweb%3D1%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgroupsg001.sharepoint.com%2Fsites%2FFTClients%2FShared%2520Documents%2Ffichier.xlsx%3Fweb%3D1%3C%2FA%3E%22%2C%20I%20access%20it%20but%20the%20multi-access%20mode%20does%20not%20work%20(and%20so%20if%20someone%20is%20already%20on%20the%20file%2C%20I%20can%20not%20access%20it).%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3EI%20tried%20to%20change%20the%20url%20to%20specify%20to%20open%20it%20in%20shared%20mode%20(via%20the%20url%20%3CA%20href%3D%22https%3A%2F%2Fgroupsg001.sharepoint.com%2F%3Ax%3A%2Fs%2Fsites%2FFTClients%2FShared%2520Documents%2Ffichier.xlsx%3Fweb%3D1%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgroupsg001.sharepoint.com%3CSTRONG%3E%2F%3Ax%3A%2Fs%3C%2FSTRONG%3E%2Fsites%2FFTClients%2FShared%2520Documents%2Ffile.xlsx%3Fweb%3D1%3C%2FA%3E%20)%20but%20this%20time%20I%20get%20the%20following%20error%20messages%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PaulineG1986_0-1654676101676.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22PaulineG1986_0-1654676101676.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F378408iBCC7AD252E3D71C4%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PaulineG1986_0-1654676101676.png%22%20alt%3D%22PaulineG1986_0-1654676101676.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E(if%20the%20file%20is%20closed)%3C%2FP%3E%3CP%3Eor%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PaulineG1986_1-1654676418803.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22PaulineG1986_1-1654676418803.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F378411i38B45CFF072E1A16%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PaulineG1986_1-1654676418803.png%22%20alt%3D%22PaulineG1986_1-1654676418803.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E(if%20the%20file%20is%20open)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EDo%20you%20know%20then%20how%20I%20can%20access%20this%20file%20in%20shared%20mode%20from%20an%20Outlook%20VBA%20macro%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20return%2C%3C%2FP%3E%3CP%3EPauline%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Bonjour,

J'essaie d'ouvrir un fichier excel partagé (sur un sharepoint) à partir d'une macro VBA Outlook.

Lorsque j'indique l'url suivante "https://groupsg001.sharepoint.com/sites/FTClients/Shared%20Documents/fichier.xlsx?web=1", j'y accède mais le mode multi-accès ne fonctionne pas (et donc si quelqu'un est déjà sur le fichier, je ne peux pas y accéder).

J'ai essayé de modifier l'url pour préciser de l'ouvrir en mode partagé (via l'url  https://groupsg001.sharepoint.com/:x:/s/sites/FTClients/Shared%20Documents/fichier.xlsx?web=1 ) mais j'obtiens cette fois les messages d'erreur suivants : 

PaulineG1986_0-1654676101676.png (si le fichier est fermé)

ou

PaulineG1986_1-1654676418803.png (si le fichier est ouvert)

 

Savez-vous alors comment je peux accéder à ce fichier en mode partagé à partir d'une macro VBA Outlook?

Merci d'avance pour votre retour,

Pauline

0 Replies