Tried OLEObjects before - used your idea as well and keep getting:

Run Time Error '1004':
Unable to get the OLEObjects property of the Worksheet class.