Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Rename Excel Sheets
Message
De
06/04/2007 12:44:48
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Rename Excel Sheets
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01213003
Message ID:
01213003
Vues:
108
Dear Experts
select path1;
	from cheqs;
	where bank= (thisform.pageframe1.page5.text6.value);
	and branch= alltrim(thisform.pageframe1.page5.text3.value);
	into cursor acc2

for x=1 to oexcel.activeworkbook.sheets.count
	select acc2
	scan
		pa=path1
		 oexcel.Sheets(x).Name = juststem(pa)
		endscan
endfor
The above procedure shows following error message
OLE IDispatch exception code 0 from Microsfot Office Excel:
Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook referenced by Visual Basic ....

Please help
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform