Hi there,
I am trying to output my data to .xlsb on a sheet called "TESTA" using the append to existing sheet option.
I keep getting the error of:
Error: Output Data (8): Error opening query: Microsoft Access Database Engine: The Microsoft Access database engine could not find the object 'TESTA'. Make sure the object exists and that you spell its name and the path name correctly. If 'TESTA' is not a local object, check your network connection or contact the server administrator.\3011 = -543884569

I have the database engine 2010 installed and tried the solution to add $, so it becomes "TESTA$". Unfortunately still no luck to have it fixed. If I use exactly same sheet, only change from xlsb to xlsx, everything will be working as expected.
Any help is appreciated.
Cheers.