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

**Norie** · 10-02-2013, 10:49 AM

Why are you using the clipboard?

Excel has built-in methods to import data from the web.

Those methods can easily be automated with code.

**sktneer** · 10-02-2013, 02:08 PM

Originally Posted by Norie

Why are you using the clipboard?

Excel has built-in methods to import data from the web.

Those methods can easily be automated with code.

Because when I export the data with the link provided on a webpage, a new browser window opens and that contains the data with comma delimiter in the format as same as I provide in my post #16. From there I have to copy the data and use it as per my requirement. I have tried to export directly from the web but that page doesn't contain the data link to do that. It only gives you the option to open it in a new window with csv format.

Regards.