Excel VBA link to files in Teams

%3CLINGO-SUB%20id%3D%22lingo-sub-1506009%22%20slang%3D%22de-DE%22%3EExcel%20VBA%20link%20to%20files%20in%20Teams%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1506009%22%20slang%3D%22de-DE%22%3E%3CP%3EHi%2C%20I%20have%20a%20question%20concerning%20excel%20VBA.%20At%20the%20moment%20I%20have%20a%20link%20in%20my%20code%20to%20another%20.xlsm%20file%20on%20my%20computer.%20It%20looks%20like%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Estr_PfadKonfig%20%3D%20%22Z%3A%22...%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20I%20want%20to%20share%20this%20file%20with%20other%20people%20on%20Microsoft%20Teams%20for%20everyone%20to%20work%20with.%20My%20question%20is%20now%2C%20can%20I%20create%20a%20link%20in%20VBA%20which%20leads%20directly%20to%20the%20file%20in%20Microsoft%20Teams%20without%20having%20to%20save%20it%20locally%20on%20my%20computer%3F%20Or%20is%20it%20only%20possible%20for%20VBA%20to%20acces%20files%20which%20are%20saved%20locally%20on%20my%20hard%20drive%3F%3C%2FP%3E%3CP%3EThanks%20for%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1506009%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Frequent Visitor

Hi, I have a question concerning excel VBA. At the moment I have a link in my code to another .xlsm file on my computer. It looks like:

 

str_PfadKonfig = "Z:\..."

 

Now I want to share this file with other people on Microsoft Teams for everyone to work with. My question is now, can I create a link in VBA which leads directly to the file in Microsoft Teams without having to save it locally on my computer? Or is it only possible for VBA to acces files which are saved locally on my hard drive?

Thanks for the help!

0 Replies