Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Relative paths and office 2013
Message
 
À
12/11/2015 10:41:32
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:
01627369
Vues:
57
>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() :-)
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