Thread: Supress dialog box when MS query returns more than 65536 rec's
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Asha Asha is offline
external usenet poster
  
Posts: 12
Default Supress dialog box when MS query returns more than 65536 rec's
When the query from Microsft query builder executes and returns data which
exceeds the sheet limit (65536 rows), a dialog box prompting (ok/cancel) gets
displayed. Is it possible to supress this dialog box, either through settings
or through VBA code? either ways plz suggest the way to do it.
Reply With QuoteReply With Quote