Forum Discussion

Zoand's avatar
Zoand
Copper Contributor
Jul 07, 2020

Excel VBA link to files in Teams

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!

excel
Macros and VBA

1 Reply

  • Amapola67's avatar
    Amapola67
    Copper Contributor
    Feb 21, 2022
    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)

Resources