paddysheeran
08-08-2014, 04:09 AM
Hi all,
I've built my code to create a powerpoint slide deck based upon tables and charts in excel.
The powerpoint file is located on sharepoint. I can check if the file can be checked out and then check the file out, run the process for transfering the data to powerpoint and then save and check the powerpoint back in.
What I want to do is be able to save the powerpoint presentation with a different file name back to the same sharepoint location and disregard the original check out.
PPPres.Saveas "Https://shaprepointsite/ & Format(Date_V,"mm_yy"),ppSaveAsPresentation
The code above looks to be working then I get the error message "Run-Time error '-2147467259 (800004005)': There is insufficient memory available to complete operation
Has anyone come across this problem and been able to find a work around?
many thanks,
Paddy.
I've built my code to create a powerpoint slide deck based upon tables and charts in excel.
The powerpoint file is located on sharepoint. I can check if the file can be checked out and then check the file out, run the process for transfering the data to powerpoint and then save and check the powerpoint back in.
What I want to do is be able to save the powerpoint presentation with a different file name back to the same sharepoint location and disregard the original check out.
PPPres.Saveas "Https://shaprepointsite/ & Format(Date_V,"mm_yy"),ppSaveAsPresentation
The code above looks to be working then I get the error message "Run-Time error '-2147467259 (800004005)': There is insufficient memory available to complete operation
Has anyone come across this problem and been able to find a work around?
many thanks,
Paddy.