Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error opening Excel file
Message
 
 
À
15/12/2011 17:52:14
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 6 SP5
Divers
Thread ID:
01531156
Message ID:
01531159
Vues:
55
>>>Hi,
>>>
>>>An automation process that used to work is now failing, in Excel 2010, for security reasons. Apparently Excel finds the idea of being automated to open an Excel file suspicious.
>>>
>>>The relevant commands are:
>>>
>>>
>>>copy to (lcTempFile) type XLS
>>>...
>>>loWorkbookTemp = This.oExcel.oApp.Workbooks.Open(lcTempFile)
>>>
>>>
>>>Excel - if it was previously open - says something about the trust center (similar to the message below, shown in Visual FoxPro).
>>>
>>>After accepting the message in Excel, Visual FoxPro gives the error message "You are attempting to open a file type that is blocked by your File Block settings in the Trust center..."
>>>
>>>I have used COPY TO ... TYPE XLS to make an Excel automation faster - transfer an entire DBF at once - since transferring one cell at a time would be exceedingly slow, especially for large files.
>>>
>>>Any ideas, how best to handle this?
>>>
>>>TIA,
>>>
>>>Hilmar.
>>
>>Where you're creating that file? I also think I saw this or similar problem discussed either here or in MSDN VFP forum.
>
>The filename is, for example, c:\docume~1\admini~1\config~1\temp\_3DUI4A4Z7.xls".
>
>This filename is generated by the following function:
>
>FUNCTION TempFileName()
>	* Return unique filename, located on the TEMP path.
>	return sys(2023) + "\" + sys(2015)
>ENDFUNC && TempFileName
>
>
>Regards,
>
>Hilmar.

Just for kicks, will you get the same error if you create the file in, say, c:\ExcelReports\ directory?
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform