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…

    1 Response to "Macro – Imported data with date column, shows incorrect date"

    • admin

      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