Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace into excel
Message
 
To
10/10/2004 03:47:35
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00948894
Message ID:
00950403
Views:
24
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform