Recent content by is250sp

I couldn't find Microsoft Excel 12.0 Object Library on the list, so I selected 11, but it works! Thanks everyone!

I am getting "Compile Error: User-defined type not defined" and the code highlighted is oExcel as Excel.Application

I found this code online and it works, however, there are 2 issues. 1. It creates an Excel file called OT Allocation.xls. When I open it, click on Window in the main menu, it actually shows 2 files are opened, the other one called Book 1. Book 1 contians only the header row. When I close...