Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
write data to two excel sheets
Hi All,
I am trying to enter some data in excel file using a VB Appl. I have a huge data with 3 Columns and around 2,00,000 rows. I have a code which writes this data to excel file but I am unable to do so as Max rows are 65K in excel. I want to input the data to 2 Sheets in same excel file. Can somebody tell me how can I do the same. A small VB Code will be of a great help. Thanks, Suyog |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
write data to two excel sheets
Hi Suyog:
You have a line count which increments on every line read and when the line count reaches 65536 you move to the next sheet. Unless you are in X12 you will need 31 sheets which is an lot of data. Maybe access or another database is a better solution? If you post your code I will have a look at it. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "suyog_linux" wrote: Hi All, I am trying to enter some data in excel file using a VB Appl. I have a huge data with 3 Columns and around 2,00,000 rows. I have a code which writes this data to excel file but I am unable to do so as Max rows are 65K in excel. I want to input the data to 2 Sheets in same excel file. Can somebody tell me how can I do the same. A small VB Code will be of a great help. Thanks, Suyog |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Write Macro to Fix Data Alignment (Data dump from Crystal to Excel | Excel Discussion (Misc queries) | |||
Macro to read and write data to multiple sheets | Excel Programming | |||
Best way to write an app using Excel sheets that doesnt look like excel | Excel Programming | |||
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
Write Data to Excel Database | Excel Programming |