+ Reply to Thread
Results 1 to 3 of 3

Close Onedrive at start of Macro, open at end of Macro

  1. #1
    Registered User
    Join Date
    09-21-2021
    Location
    Los Angeles
    MS-Off Ver
    365
    Posts
    87

    Close Onedrive at start of Macro, open at end of Macro

    I am running a macro that is creating about 250 separate files that are synced with OneDrive / Sharepoint / Teams - and if the One Drive sync is turned on when the macro starts, it fails. If I pause one drive syncing, then the macro runs perfectly.

    Is there a way to code into the macro to pause one drive sync automatically so the user does not have to remember to do this?

  2. #2
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Close Onedrive at start of Macro, open at end of Macro

    I dont believe there is any VBA interaction with OneDrive but I'd imagine it can be done by using Shell commmands.
    If someone has helped you then please add to their Reputation

  3. #3
    Registered User
    Join Date
    09-21-2021
    Location
    Los Angeles
    MS-Off Ver
    365
    Posts
    87

    Re: Close Onedrive at start of Macro, open at end of Macro

    I am not familiar with shell type stuff at all. I found a couple things on the google, but none have worked so far.

    Do you have any ideas on how to work with these?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro creates multiple open onedrive folders
    By rob vandebergh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2020, 02:33 PM
  2. Open & close the Active excel file by vba macro (Macro Modification)
    By quirkybox in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2020, 07:00 AM
  3. [SOLVED] Open & Close vba macro
    By ZMAFC94 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2018, 07:27 AM
  4. [SOLVED] Issue with Open, copy, close Macro - when trying to close workbook Clipboard error
    By seanpcorbett1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-13-2016, 05:14 PM
  5. Ignore that the file is already is open, or close it to start with.
    By Dkstaurs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2014, 09:14 AM
  6. Macro to close workbook open in IE?
    By martin.mcgarry in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2010, 02:13 PM
  7. Macro to open workbook, run macro, save, and close.
    By rclark430 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2008, 08:07 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1