Without seeing the relevant parts of your source code, it's hard to give concrete advice.

Have you loaded Win32::OLE as the error message suggests?

use Win32::OLE;
[download]

Also consider looking at the code in other replies here, like 781872, for getting a minimal example of what should work. Especially Using Win32::OLE and Excel - Tips and Tricks.