My colleague and I are trying to pull data from SAP into excel using VBA to automate the process. He has a script that is able to successfully perform the task, but when I run it on my computer it falls out at the line shown below. The portion of the script shown is meant to automatically log the user onto the correct client server of SAP and then find the relevant data.
Any help would be appreciated, thanks.
