I'm currently writing a program to automate the creation of a purchase order for my company. The spreadsheet already exists and I have no problem filling in the cell values. The problem is that there are option buttons, checkboxes, comboboxes that I need to check the current value and then write a new value. I've looked at the Excel object model many times and I must be missing something. I thought I found the solution by using the OLEOBJECTS collection but each sheet had a COUNT of 0.

Any help would be appreciated. Thanks.

Aaron Jacka