
Originally Posted by
mannaggia
My next problem is that the above code seems to default to saving it on the Desktop.
In the default filename include the path to the default directory you want to use. Example

Originally Posted by
mannaggia
To complicate matters, I need this file to be saved in a SharePoint document library.
A different kettle of fish altogether. Sharepoint is an application not simply a location so you would need to interact with it. I use Sharepoint at work but it's a tad flaky and I wouldn't want to be tasked with using automation with it. I cannot help you with that piece but you may want to try searching for answers on a specific Sharepoint forum.
regards,
Graham
Bookmarks