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 upload@everydayexcel.com

Leave a Reply

You must be logged in to post a comment.

s2Member®