I am using the workbook.open method in read only mode and then converts all the chart objects in the excel file into png images. The problem is that it takes a while for excel to produce charts correctly and the script executes as soon as the file is opened, because of this the images are not the same as the actual charts and the curves are not proper.
What is the way to insert a delay in the script so that the charts are produced correctly and then they are exported into images.
What is the way to insert a delay in the script so that the charts are produced correctly and then they are exported into images.