Peter ...
Yes, you'll need to parse the date as well. The format of the Decimal number (Float) in your file appears to be:
CYYMMDD
Where:
C is a Century code ... 0 = 1900, 1 = 2000, etc.
YY - 2 Digit Year
MM - 2 Digit Month
DD - 2 Digit Day
Can you take care of this? The translation from your file "Float" format to VBA "Single" won't take more than 5 lines of code. You're going to have to buy us all a beer ... and one for Declan's horse too! (that big oat oaf doesn't buy beer) Anyway, this is much more fun than working crossword puzzles. Forget Sudoku or Soduko or whatever that junk is.
Reply With Quote