Code works like a breeze on my side with Excel 2003, Seven and Internet Explorer 9
but may not work on other Windows or IE versions …
Code workbook must be opened alone to execute the procedure.
IE must be visible during the procedure to simulate keystroke.
Website csv text file is opened in a new workbook, event
Deactivate procedure detects it.
If the file is not splitted in columns, use for example
TextToColumns method (or Macro Recorder)
by amending the event procedure, beginner level …
Code to paste directly to workbook module ThisWorkbook :
Do you like it ? So thanks to click on bottom left star icon « Add Reputation » !
Bookmarks