Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Relative paths and office 2013
Message
From
12/11/2015 10:41:32
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Relative paths and office 2013
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:
01627367
Views:
52
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
*****************
Srdjan Djordjevic
Limassol, Cyprus

Free Reporting Framework for VFP9 ;
www.Report-Sculptor.Com
Next
Reply
Map
View

Click here to load this message in the networking platform