Guinaba
Board Regular
- Joined
- Sep 19, 2018
- Messages
- 218
- Office Version
- 2016
- Platform
- Windows
Hi guys,
I have 4 VBA macros running in order to get my final report result and format. I have tried to combined all of them in one sub just using call functionality but the results that I am getting are not the same, when I run them individually. So I tried to delayed each call 5 sec 'Application.Wait (Now + TimeValue("0:00:05")) but still didn’t worked. Not sure if I have to delay even more or if there is another better solution. Any suggestions?
1.Refresh Data
2.Run Coverage
3. Refresh Report
4. Format Report
I have 4 VBA macros running in order to get my final report result and format. I have tried to combined all of them in one sub just using call functionality but the results that I am getting are not the same, when I run them individually. So I tried to delayed each call 5 sec 'Application.Wait (Now + TimeValue("0:00:05")) but still didn’t worked. Not sure if I have to delay even more or if there is another better solution. Any suggestions?
1.Refresh Data
2.Run Coverage
3. Refresh Report
4. Format Report