Thread: after clearcontents() new data is positioned below the cleared ran
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
DM Unseen DM Unseen is offline
external usenet poster
  
Posts: 233
Default after clearcontents() new data is positioned below the cleared ran
Since you need to write excel code anyway, why do you push the data to
excel with DTS instead of pulling the data with
Queries/QueryTable/PivotTable/ADO ?

Reply With QuoteReply With Quote