Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Rename Excel Sheets
Message
From
06/04/2007 12:44:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Rename Excel Sheets
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01213003
Message ID:
01213003
Views:
107
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
Next
Reply
Map
View

Click here to load this message in the networking platform