Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I set the starting
Message
De
01/02/2006 08:01:45
 
 
À
31/01/2006 19:39:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP1
Divers
Thread ID:
01092121
Message ID:
01092266
Vues:
26
I've never actually used these objects before, but going through Excel's VBA editor, I see this FileDialog object that has DialogType and initialFileName properties. It looks like that MIGHT be useful to you. The Excel application object itself has a DefaultFilePath property, but I'm not sure if that would help you in this situation.

Alternately, is it possible in your app for you to use Fox's putfile() to get the desired save location & then issue this workbook.saveas() to automatically write to the desired location?

>OK, back to my original question. How do I set the path that the Excel file will be saved in if the user decides to save the file? (Of course, the user could override this by doing "Save As" on their own.)
>
>>Yes it does save the spreadsheet under specified full name.
>>
>>>
>>>One last question. Does that actually save the spreadsheet? Or does it just set the full path for the name that it will be saved as if the user later decides to save it? (OK, that was really two questions, wan't it?)
>>
>>>>Specify the fullpath name in the SaveAs:
>>>>
>>>>
oX.ActiveWorkbook.SaveAs(cFolder+cExcelFileName)
Paul A. Busbey
Victoria Insurance
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform