>If you have a version of Excel that will do all those things, then you >should be able to write a very short VBA macro that will do it. >Undoubtedly simpler than the route you are proposing.
Thanks for reply David, i was thinking about going this route, the problem is i will have to do it on a continuous basis (new file every day) so it's not a very practical route for me, unless opening old format Excel files is impossible in R. -- View this message in context: http://www.nabble.com/Reading-Excel-5.0-files-with-RODBC--tp22929781p22944406.html Sent from the R help mailing list archive at Nabble.com. ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
