Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel spreadsheets to one workbook
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 7
Divers
Thread ID:
01101620
Message ID:
01102223
Vues:
17
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform