>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!!