View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
suyog_linux suyog_linux is offline
external usenet poster
 
Posts: 7
Default 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