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

    Open strFilename For Output Access Write As #iFn

    How i can change this code on worked on web ?

    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.

    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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!