letsdogethel
10-26-2018, 01:35 AM
Apologies for lack of forum etiquette (first post)
I am trying to make a button in powerpoint that will save a copy of the powerpoint to onedrive.
why not just use the menus you may ask? well the macro also removes the VBA code.
The problem is the code I am using is incredibly slow. Typically, a 75mb powerpoint will appear in the onedrive folder immediately if you save conventionally
but will take over a minute using a macro button. Using VBA, a dialogue box appears with the "uploading to sharepoint" dialogue box which prevents the user from
doing anything for the duration.
code below
ActivePresentation.SaveAs FileName:= _
"https://companyname-my.sharepoint.com/personal/john_doe_companyname_com/Documents/testpowerpointfile.ppsx"
The above code is what the macro recorder in Word and Excel suggest. Unfortunately, microsoft removed the recorder for powerpoint so I have no idea how it is supposed to be done
to reduce the upload time. any help appreciated
I am trying to make a button in powerpoint that will save a copy of the powerpoint to onedrive.
why not just use the menus you may ask? well the macro also removes the VBA code.
The problem is the code I am using is incredibly slow. Typically, a 75mb powerpoint will appear in the onedrive folder immediately if you save conventionally
but will take over a minute using a macro button. Using VBA, a dialogue box appears with the "uploading to sharepoint" dialogue box which prevents the user from
doing anything for the duration.
code below
ActivePresentation.SaveAs FileName:= _
"https://companyname-my.sharepoint.com/personal/john_doe_companyname_com/Documents/testpowerpointfile.ppsx"
The above code is what the macro recorder in Word and Excel suggest. Unfortunately, microsoft removed the recorder for powerpoint so I have no idea how it is supposed to be done
to reduce the upload time. any help appreciated