Rampage123
10-12-2015, 03:11 AM
Hi all,
I am facing an issue while writing my VBA code
So, I am asking my VBA code to pull out data from a SQL run (refresh existing data every time data is pulled) and then do operations on that (like sort, include more columns using vlookup and so on)
However, pulling data from SQL is taking time and in the meanwhile other operations like sorting are getting completed. Because of this, I am looking at wrong results
Is there a way to ensure the other operations run only post data pulling is over
Thanks
I am facing an issue while writing my VBA code
So, I am asking my VBA code to pull out data from a SQL run (refresh existing data every time data is pulled) and then do operations on that (like sort, include more columns using vlookup and so on)
However, pulling data from SQL is taking time and in the meanwhile other operations like sorting are getting completed. Because of this, I am looking at wrong results
Is there a way to ensure the other operations run only post data pulling is over
Thanks