View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jamie Collins Jamie Collins is offline
external usenet poster
 
Posts: 593
Default Reading data from an excel sheet and writing to another

Rain wrote:
Kindly refer http://www.rondebruin.nl/ado.htm for function

GetDataSheet

On the resulting sheet, the first row which contains numbers is

getting
changed to
F(column number) as in

First Row: ABC F2 F3 DEF F4 F5


Change HDR=Yes to HDR=No (HDR specifies whether the source has column
headers).

Jamie.

--