Excel automation Script

Hi,

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) <> "" Then
If 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?

Thanks.