Experience Level: Intermediate
Problem with excel macro. Macro to import data from multiple .csv files into seperate excel tabs. Problem relates to the date field in macro - 6 May 2010 is shown as 5 June 2010 in excel. Have no control over input .csv file. Fixed price of £10 or your alternative offer to resolve. Macro needs to execute without any user intervention like prompts. Excel and .csv attached. I need working solotion with brief explanation if required.
There are no clarification messages.