Error when script stored on mapped sharepoint drive

[Marc-Anderson]

Description

When the compiled script and xlsx hotstring file are stored in a mapped sharepoint drive, the below error may occur. I have been working on suboptimal internet connection the last few weeks and i get this error periodically when trying to start the script. This doesnt seem to happen when the internet is consistent but i have not tested thoroughly.

1. This does not happen every time
2. Everything works as expected once the script has started successfully.
3. I have not tested this on the csv version but it may be the case that the issue is with excels readiness.

Temporary Solution:

click no, wait a second, start the script again(this has worked for me every time on the first try)

Error Messge

Error: Ox800AC472 -
Specifically: UsedRange
Line#
058: hotstringWorksheet.UsedRange.Offset(1).Sort(XLColumns(3), 1)

Continue Running The Script?

Considerations

I have tested this and have not experienced it again but i think the issue will persist

while !XL.Ready || !XL.Interactive {
    Sleep, 500
}