i have a listbox in my vb6 program with file paths of all employees
i made all enployee files with my xl template that's why cell names
are same like empname, ampdesg(employee designation), tcustomer,
tvisit, and tarea etc. Then i make a master xl sheet in which i named
some cells like emp1name, emp1desg, tcustomer1 and so on then emp2name, emp2desg etc.
I want my vb6 program open each file by path in listbox and move values
to master sheet like xx.rage(xx).value = yy.rang(yy).value where x is
master sheet range and y is each employee sheet range.
Kindly help me solve this Problem i'll be thankful 2 u.
I have excel 2002 and vb6
i made all enployee files with my xl template that's why cell names
are same like empname, ampdesg(employee designation), tcustomer,
tvisit, and tarea etc. Then i make a master xl sheet in which i named
some cells like emp1name, emp1desg, tcustomer1 and so on then emp2name, emp2desg etc.
I want my vb6 program open each file by path in listbox and move values
to master sheet like xx.rage(xx).value = yy.rang(yy).value where x is
master sheet range and y is each employee sheet range.
Kindly help me solve this Problem i'll be thankful 2 u.
I have excel 2002 and vb6
