title: Press OK on pop-up alert window via VBA
body: <p>Having an issue, I have written a Macro ,that refreshes every 2 min, to upload data from a webpage and the last step of my Macro is using "Text to column" function so that it will be splitted into columns nicely.</p>
  
  <p>The problem appears here everytime it gets to executes this "Text to column" it asks if I want to overwrite the columns(and I DO), but I need to press manually OK.</p>
  
  <p>Is there any way to make VBA press this OK button in the alert?</p>
  
  <p>Thank you very much!</p>