I have an email module in Access 2016 connecting to excel 2016 spreadsheet. The code calls Outlook. When I get to the following code block, I am prompted for a password:
The code sticks at FileCopy xlFile, sendFile
FileCopy xlFile, sendFile
Set xlapp = excel.Application
Set xlBk = xlapp.Workbooks.Open(sendFile)
xlBk.RefreshAll ' refreshall was not in the library
On Error Resume Next
For Each cn In xlBk.Connections
cn.Delete
17 hours ago
The error where the code stops is Error 70, permission denied.
Thank you.
2Rowdy
The code sticks at FileCopy xlFile, sendFile
FileCopy xlFile, sendFile
Set xlapp = excel.Application
Set xlBk = xlapp.Workbooks.Open(sendFile)
xlBk.RefreshAll ' refreshall was not in the library
On Error Resume Next
For Each cn In xlBk.Connections
cn.Delete
17 hours ago
The error where the code stops is Error 70, permission denied.
Thank you.
2Rowdy