How to convert exported text date to desired date format with excel vba.

Originally Posted by Norie

Why would you run it a 2nd time?

By the way, where is the data coming from and how/why does it end up in the clipboard?

I copy the data from the web and instead of pasting this data into a text file , save it and then import data from the saved text file to the excel sheet, I just want to copy the data from the web and then run the code in excel sheet which would extract the data present in the clipboard.

I have to repeat this process everyday i.e. I copy the new data from the web and come back to the excel sheet and here my code has a line of code which clears the older data already there in the sheet before extracting the new data from the clipboard . That's it. Its all about automation of the work which I need to do everyday and macros are best friends to help you in this scenario.

Thanks & Regards.