Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Replace into excel
Message
 
À
10/10/2004 03:47:35
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00948894
Message ID:
00950403
Vues:
25
See my notes below

>hi,
>
>i'm sorry to late.
>
>Does the Excel Sheet have the very same FONT NAME that you use in FoxPro?

No, you should set the appropriate font in Excel.

>i can choice excel font.
>how i can choice FoxPro font?

Are you talking about the font having name "FOxPro font", or about the font that you are using while browsing the table in VFP?

>
>Do you use binary data field in the Foxpro table? no

I would recommend to use binary in your case.

>
>i get a message when i open the excel sheet (test1.xls is loced fro editing by
> "my use name". open read only,or click to notify....
>
>and after that another message (test1.xls is read only to save a copy click ok,then give the work book anew name in the save as...
>
>how i can skip for this messages ,just when i go to excel just open my sheet. without any message.

What Excel version do you use? In versions where I work, the file is opened read-only without any warning by default in automation. Anyway, try to set:

oExcel.DisplayAlerts = .f.

If you are going to save the file after editing, then you do not have any choise except SaveAS, as then file is opened by somebody else.
If you are not going to save the edited new version, then, again, oExcel.DisplayAlerts = .f. should help.

>
>thanks.
>best regards.
>m.qasem
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform