canberrasnag
Programmer
I have found, that sometimes I load an HTML file into excel to extract data, sometimes if formats numeric fields as dates, but not always. Eg: 1.19 is changed to mar.00. When I click on this cell I see 01.01.1900 . It appears to be a date formatted field. this could be a C++ bug.
I tried to fix this with VBscript, with moderate success.
I managed to exctract the 1.19 and use it as such, But I have now noticed, that when I extract this "date" field for manipulation, the vbscript or the application ( I don't know which) subtracts one day from the date. so 01.01.1900 becomes 21.12.1890 which totally stuffs up my numbers.
I am using .vbs files.
Help would be greatly appreciated.
Thanks
I tried to fix this with VBscript, with moderate success.
I managed to exctract the 1.19 and use it as such, But I have now noticed, that when I extract this "date" field for manipulation, the vbscript or the application ( I don't know which) subtracts one day from the date. so 01.01.1900 becomes 21.12.1890 which totally stuffs up my numbers.
I am using .vbs files.
Help would be greatly appreciated.
Thanks
