Macro – Imported data with date column, shows incorrect date

June 13th, 2013 by stitan2005 stitan2005

Dear Excel specialist,
I have been working on this macro for half a day but i just cant find a solution to it.
Hope you can help me with it…

I’m trying to write a macro that can open a log file, import it into excel and perform sorting function.
But somehow, the imported data by macro, keeps showing incorrect date data.
If I manually import the data, all the date entries are fine.

Hope you can help me…

One Response to “Macro – Imported data with date column, shows incorrect date”

  1. admin admin Says:

    Could you send us a sample copy of the file you are working on so that we could test it out to find out what happen? You can send it to

Leave a Reply

You must be logged in to post a comment.