LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
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.

--

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
reading data from hidden sheet Atiq Excel Discussion (Misc queries) 4 January 27th 10 08:14 PM
Need sample for reading value from and writing value to cell E53 from outside Excel Tony Bansten Excel Discussion (Misc queries) 1 June 17th 08 07:03 AM
Reading data from another sheet where data is in variable cells JDB Excel Discussion (Misc queries) 4 January 2nd 07 11:04 AM
Fast reading/writing of CSV files Chris Jakeman Excel Programming 2 August 6th 04 10:29 AM
Reading and writing from/into several worksheets Chris Excel Programming 3 December 4th 03 08:24 PM


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"