Use Macro on Teams/Sharepoint/Onedrive

  • Hello,
    I have a macro which is correct work on a desktop.
    When I try work on it on teams/SharePoint/one drive I get an error


    Code
    1. Open strFilename For Output Access Write As #iFn




    How i can change this code on worked on web ?

    Code
    1. Sub send()

  • Run-time error "52" : Bad file name or number

    How ?

    In my first post i showed my code.
    I used it on work in desktop, but already we must use Teams - and on Teams i have RT error 52. So the file name is the same like in desktop = correct.

  • How are you running code in a workbook in Teams? That shouldn't work at all.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why