in reply to PerlApp can't find bound module
Although you say that the module is listed in the Files tab on PerlApp, I'd recommend trying to manually add it to the "Added modules section" along with any modules that it uses. I've had to do this a few times when PerlApp didn't included required modules. If you're still having problems, you might also check out their user forums.
As for alternate methods for getting date/time data out of Excel, there's a few other methods.
UPDATE:
I found the information that I was looking for. The link is below. The first few paragraphs explains the whole number for dates and decimals for time thing. Further on down, they have examples about doing some date/time math in Excel, but that will give you an idea of what you can do with your Perl code to do your own conversion.
http://support.microsoft.com/kb/214094
One last note about the link above. Toward the end, it describes the difference in how Excel handles dates on Windows vs. on Macs. If you decide to write your own code for the date/time conversion and plan to make it cross-platform compatible, you might want to keep that in mind.
|
|---|