Hi all,
Hope someone can help - I have exhausted looking for a solution!
At present my Database creates a pdf report from a result and saves it to a OneDrive directory, which uploads the file into Sharepoint.
I would like to save the file directly to Sharepoint but have not fathomed out how to do so. I would also like to link to the Sharepoint directory and list files, the same way as I am able to on the OneDrive directory
I have tried doing a direct output to the Sharepoint directory, and also to map a drive to the Sharepoint directory (also failed)
For direct export, this is the last command:
DoCmd.OutputTo acOutputReport, SrcFile, acFormatPDF, DestPath & DestFile & ".pdf", ShowPdf, "", 0, acExportQualityPrint
The DestPath was to the local OneDrive on the server - which worked fine.
I have replaced the DestPath with DestPath = "https://xxxx610.sharepoint.com/:f:/g/EgTCQNQP0sJBuLBeUm8IKBUBr9tnBd9-TwxiyNz2exBY1w/ Password / EmailAddress"
(and tried without a password / email address)
Have also tried the direct url of "https://xxx610.sharepoint.com/Shared%20Documents/Forms/AllItems.aspx?viewid=00000000%2D0000%2D0000%2D0000%2D000000000000&id=%2FShared%20Documents%2FLab%2FeSig%5FTech2/"
Any ideas?
Hope someone can help - I have exhausted looking for a solution!
At present my Database creates a pdf report from a result and saves it to a OneDrive directory, which uploads the file into Sharepoint.
I would like to save the file directly to Sharepoint but have not fathomed out how to do so. I would also like to link to the Sharepoint directory and list files, the same way as I am able to on the OneDrive directory
I have tried doing a direct output to the Sharepoint directory, and also to map a drive to the Sharepoint directory (also failed)
For direct export, this is the last command:
DoCmd.OutputTo acOutputReport, SrcFile, acFormatPDF, DestPath & DestFile & ".pdf", ShowPdf, "", 0, acExportQualityPrint
The DestPath was to the local OneDrive on the server - which worked fine.
I have replaced the DestPath with DestPath = "https://xxxx610.sharepoint.com/:f:/g/EgTCQNQP0sJBuLBeUm8IKBUBr9tnBd9-TwxiyNz2exBY1w/ Password / EmailAddress"
(and tried without a password / email address)
Have also tried the direct url of "https://xxx610.sharepoint.com/Shared%20Documents/Forms/AllItems.aspx?viewid=00000000%2D0000%2D0000%2D0000%2D000000000000&id=%2FShared%20Documents%2FLab%2FeSig%5FTech2/"
Any ideas?