apparently my tables are going to be too big for a flexgrid
That's news to me.. what is the problem/error here?

i tried setting oXLApp.Visible = True so i can have the spreadsheet open instead of a flexgrid but it is telling me object required
Presumably you have the scope wrong - you have declared oXLApp is a different sub to where you are using it.