Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel spreadsheets to one workbook
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7
Miscellaneous
Thread ID:
01101620
Message ID:
01102223
Views:
18
Hi Craig,

I'm sorry to be a bother. I found, that the first Excel file is updated too and also that the name of the file in the Excel title is wrong (not the name I want for my final result, but the first excel file instead). I've made attempt to fix the program, but unsuccessfully.

Here is how I try to call it:
if DBFToExcel(sys(5) + curdir()+ 'Letters Statistics ' + ;
	alltrim(str(m.tiBatch_Number)) + '.XLS', @laHeader_Info, ;
	"Letters Statistics") ==""
	local array laExcelFiles[3]
	laExcelFiles[1]	= sys(5) + curdir()+ 'Resolution ' + ;
	alltrim(str(m.tiBatch_Number)) + '.XLS'
	laExcelFiles[2]	= sys(5) + curdir()+ 'Name Search ' + ;
	alltrim(str(m.tiBatch_Number)) + '.XLS'
	laExcelFiles[3]	= sys(5) + curdir()+ 'Letters Statistics ' + ;
	alltrim(str(m.tiBatch_Number)) + '.XLS'

	=CombineExcelFiles(@laExcelFiles, ;
        sys(5) + curdir()+ 'Batch Statistics ' + ;
	alltrim(str(m.tiBatch_Number)) + '.XLS')
endif
>You're welcome Naomi.
>
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform