Excel VBA link to files in Teams

Copper Contributor

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!

1 Reply
@Zoand
I'm trying to do the same thing. Did you ever work out how to do that?
Wondering whether I can construct the link path and insert into document as a web link (rather than attachment)