adding fixture api and updated vba code to match