Hello,
my VBA code is running a VBscript to export a report from SAP so, I need to pause my VBA script to account for the time that it takes the VBscript to run. I have a function, not made by me, that checks to see if a file exist on my desktop and doesn't continue until the file exist. This works great, but this SAP report can not be saved to the desktop, it can only be exported to excel. The exported excel sheet is titled Worksheet in Basis (1). I'm hoping someone can shed some light as to where SAP exports this file to or can help edit the function to accommodate the file not being saved.
Here is the Wait for file function
Bookmarks