Use Macro on Teams/Sharepoint/Onedrive

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • 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!