Dec 09 2020
I am using the Ron de Bruin script to run an automation to send various excel files to different users - I have customized it for my needs and it works very well.
The only thing, is it possible to a SharePoint file and send that instead of a file saved locally on the machine? I tried to run the script but there is an error in the code line below:
For Each FileCell In rng.SpecialCells(xlCellTypeConstants)If Trim(FileCell) <> "" ThenIf Dir(FileCell.Value) <> "" Then.Attachments.Add FileCell.Value
Is there a way to change the code so it picks up the file saved on the SharePoint?