| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create muliple sheets using querytable
I'm currently able to export query results to an Excel file via the querytable method. It is working great... and also very fast, but it limited to 65xxx records. Is there any way for me to use a querytable and to programmatically spill over to additional worksheets should I exceed the Excel 65xxx threshold? Examples would be appreciated. Thanks. -- mdengler ------------------------------------------------------------------------ mdengler's Profile: http://www.excelforum.com/member.php...o&userid=32030 View this thread: http://www.excelforum.com/showthread...hreadid=526823 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula reference~muliple sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| Muliple formulas | Excel Worksheet Functions | |||
| Sum If on muliple conditions | Excel Worksheet Functions | |||
| Create New Workbook - Name book - 4 Sheets - Name Sheets | Excel Programming | |||
![mdengler[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
