I have macro that opens a workbook file in a website, the problem is the workbook won't open until my code is finished. I tried looping until the workbook opens but the macro just ends up in an infinite loop. Application.Wait also wont work. Hoping someone can help