Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relative paths and office 2013
Message
 
To
12/11/2015 10:41:32
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01627367
Message ID:
01627369
Views:
56
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform