Forum Discussion

nittynair's avatar
nittynair
Occasional Contributor
14 years ago

Using For loop with different sheets in an excel

Hi, My application has two pages page 1 : i need to add company details Page 2 : employee details of the above company I have put company data in sheet 1 and employee detail in...
irina_lukina's avatar
irina_lukina
Super Contributor
14 years ago

Hi,


I agree with Robert that using the For Loop operation is not a good idea. I'd either use an approach suggested by Robert, or try working with Excel via COM. For more information, please refer to the Working With Excel Files via COM help topic.