Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: surinder singh
  Where is surinder singh?
 mumbai
 India
 surinder singh
 To: M M
  Where is M M?
 Delhi
 India
 M M
 Tags
Subject: RE: Value Retention between VFP and Excel
Thread ID: 188275 Message ID: 188819 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Classes and Objects
Date: Tuesday, August 12, 2008 8:53:56 AM         
   


> >
> There is a problem if I use the above code, I have tried with curdir() but in VB it was returning the Path "C:\Documents and Settings\madhu\My Documents\myVBAoutput.txt". That is the reason why I wanted to use my application path.
>
> Is there any means of sending my VFP application path to the Excel Form and access it from the FORM.
>
> Cheers
> Madhu

you can make it dynamic
just get the TEMP path in VBA to save your file
access that file from foxpro by using TEMP Path.
VBA
MyFile = Environ("TEMP") + "\fileName.txt"

in foxpro
   aa=FILETOSTR(GETENV("TEMP")+"\FileName.txt")


by doing this you don't need to depend on the drive name or anything else


Hope it will solve your problem!


-----------------------------------------------------------------------------------------------
Regards
Surinder Singh
Email: sur200@indiatimes.com
Check my blog for details: http://weblogs.foxite.com/sur200
----------------------------------------------------------------------------------------
*If you understand what you're doing, then you're not learning anything.

ENTIRE THREAD

Value Retention between VFP and Excel Posted by M M @ 8/8/2008 2:05:03 PM
RE: Value Retention between VFP and Excel Posted by tushar @ 8/8/2008 2:12:22 PM
RE: Value Retention between VFP and Excel Posted by M M @ 8/11/2008 11:32:13 AM
RE: Value Retention between VFP and Excel Posted by surinder singh @ 8/11/2008 12:42:30 PM
RE: Value Retention between VFP and Excel Posted by M M @ 8/11/2008 3:46:54 PM
RE: Value Retention between VFP and Excel Posted by surinder singh @ 8/12/2008 6:51:02 AM
RE: Value Retention between VFP and Excel Posted by M M @ 8/12/2008 7:49:05 AM
RE: Value Retention between VFP and Excel Posted by surinder singh @ 8/12/2008 8:07:52 AM
RE: Value Retention between VFP and Excel Posted by M M @ 8/12/2008 8:43:37 AM
RE: Value Retention between VFP and Excel Posted by surinder singh @ 8/12/2008 8:53:56 AM
RE: Value Retention between VFP and Excel Posted by M M @ 8/12/2008 3:44:43 PM
RE: Value Retention between VFP and Excel Posted by M M @ 8/13/2008 4:58:17 PM
RE: Value Retention between VFP and Excel Posted by surinder singh @ 8/13/2008 6:22:14 PM
RE: Value Retention between VFP and Excel Posted by M M @ 8/18/2008 7:39:22 AM
RE: Value Retention between VFP and Excel Posted by tushar @ 8/18/2008 7:46:44 AM
RE: Value Retention between VFP and Excel Posted by M M @ 8/18/2008 1:50:07 PM
RE: Value Retention between VFP and Excel Posted by tushar @ 8/18/2008 3:09:58 PM
RE: Value Retention between VFP and Excel Posted by tushar @ 8/12/2008 9:28:09 AM