Hi Everyone, I have an excel spreadsheet that contains the itinerary of our traveling technicians. I would like to parse that info and be notified of an upcoming trip. For example: Say there is a trip coming up the Sunday after next. I would like to be warned 3 days in advance to (windows messenger or possible adding a task to scheduler, etc) make sure the tech it notified and prepared. Currently my knowledge of Perl is that of a cut and paste scripter so I thought this would be a good way to get into the thick of it. Anyway I would like to parse the .xls file and create a notification of upcoming events.
Something like this: Date = today Read in excel file ScheduleDate = date from date column (formatted) If ScheduleDate < 3 days from today's date Then notify whoever (messenger) or add a scheduled task to notify user.. Else do nothing end I read a little about Win32:OLE, and HTML::PARSER (xporting the excel into HTML), and HTML::ENTITIES. Which way is recommended? Can I do this will perl? Should I use another means (WSH, VBSCRIPT)? AD -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
