I wonder if anyone can help - i'm very new to macro's and was trying to improve one that i wrote a little while back.
In essence its a little clunky but does the job where it basically filters to various criteria in a large source data workbook, and selects some info to copy into a new work book. Currently i have to have the source data file open to run the macro that extracts the data. I've been reading some online forums and 'borrowed' some code to build in opening the source data file to the beginning of the macro. The problem is its not working but because i've adapted someone else's code i don't really know what its doing to try and fix why its not working. The correct file does open but the formatting is off. Instead of all the dates showing as dd/mm/yyyy, dome dates seem to go to mm-dd-yyyy which throws the filters off and skews the rest of the data. Can anyone give me a pointer please. How would i open the .csv file without changing any of the formatting?
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
Bookmarks