Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Visual FoxPro Shutdown under Citrix
Message
De
19/08/2005 18:40:57
Jean Haidar
Arkansas Blue Cross/Blue shield
Little Rock, Arkansas, États-Unis
 
 
À
19/08/2005 16:41:47
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01039911
Message ID:
01042434
Vues:
27
>Few bits, though: I'm not using RUN command anywhere. I get much more control over the execution of the external code using late Ed Rauh's API_APPRUN class
(download #9477) - which is really simple and doesn't get influenced by bad .pif files. Also, if you're creating an Excel spreadsheet, use Automation:


I dnot know where the RUN Command is coming from.
I am not using a RUN command and I am instantiating EXCEL with
Newobject

oExcel1=NEWOBJECT("Excel.Application")

*Then it set a default path based on some setting and assign it as follows:

oExcel1.DefaultFilePath= lcNewDefDir

* Open a workbook with this EXCEL Template
mXLSFile = "\\lrd1fil2\vfpprod\icu\libs\autogei.xlt"
oExcel.Workbooks.OPEN(mXLSFile)

* Here it will populate Excel cell in different sheets as such
oExcel.Sheets("PART A").SELECT
oExcel.RANGE("B6").SELECT
oExcel.ActiveCell.FormulaR1C1= lcCompany

*** more code in here

*-- Here show the EXCEL Document
oExcel.VISIBLE = .T.

The code work on two Citrix Servers fine, but give this error message on other Servers?


>Now if "access denied" is about a xls filename on Citrix that someone still has in use somewhere... then before trying to open that in Excel, try to open it low level, using fOpen()... if it can't open it exclusively, it won't raise an error, but will return -1 for a handle. Then you can try with a next filename.


The module will try to create a New instance of an EXEL file Template and after it generate the document and displayed on the screen, then it prompt user to Save it
to certain directory on the Network?
So it is really not using an existing EXCEL file!!
Jihan Haidar
Software Engineer
jhhaidar@sbcglobal.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform