Firstly, appreciate all the help I can get as I am not an expert in this field and am really struggling to resolve this for work.
Background, there is this excel macro that will extract data from sql. The most rows I have seen by far would be around 8k. I need to extract a month worth of data. Currently, my excel will hang or crash when I try to run the excel. I am able to generate the data if I choose a time range of 2 weeks.
I believe that my coding might be inefficient or that there could be certain settings I can change to improve this timing and successfully generate a month worth of data.
I have attached the codes below.
Thank you in advance.
Bookmarks