Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Relative paths and office 2013
Message
 
À
12/11/2015 11:10:09
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01627367
Message ID:
01627373
Vues:
41
>>>Dear All
>>>
>>>After reinstalling VFP on a new machine with Office 2013, I got into very strange situation where OLE automation will no longer
>>>accept relative paths. The same code was working ok past 10 years.
>>>
>>>It is happening only in development mode (inside VFP ide) when compiled into EXE everything works ok.
>>>
>>>
>>>
>>>cFile='\templates\some.xls'
>>>if file(cFile)  &&file does exist!
>>>  oXl.workbooks.open(cFile)      &&Cannot find file
>>>  .
>>>  ****BUT
>>>  .  
>>>  cFile='c:\templates\some.xls'
>>>  oXl.workbooks.open(cFile)      &&Opens ok
>>>
>>>  .
>>>
>>>
>>>
>>>The same goes for outlook object attaching file with relative path. As if it applies for all office (or OLE automation with office) .
>>>Did not try word or anything else.
>>>
>>>What am I missing here ?
>>>Anybody have any idea why is this happening ?
>>>
>>>
>>>TIA
>>>Sergio
>>
>>I learned to never trust relattive paths when it comes to automation.
>>The application have one MS Office has others :-)
>>That is why i always use FULLPATH() :-)
>
>Also adir(laDir, cFile)>0 is safer than File()

:-)
I prefer SYS(2000)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform