Code to check if date being imported matches a previous date and time

12/2/2018 11:17:09 PM


I am importing data off a sheet that has a date and time and I would like it to check the import and see if the date and time are the same and if they are produce a pop up asking that it looks to be the same data do you want to proceed. If they choose no to exit sub. I tried the code below but I keep getting a type mismatch error. on line " If TimeValue(OldTime) = TimeValue(MyDate) Then"

Please Login or Register  to view this content.

any thoughts

Sounds to me as though OldTime or MyDate isn't in a format that TimeValue accepts, looking at your code you're trying to use the value with.

It's hard to say for sure what is in your cells but you need to make sure your Variables are text (string) values as that is what TimeValue expects.

Best bet would be to set a break point in the code and see what is actually in OldTime or MyDate - If it's serial number then there is your problem?

If you can't get it working then upload a copy of your Workbook and we can take a look for ourselves