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


Hi,
I got stuck with another problem. Can u tell how can I unprotect a particular area of a Sheet. For example, I need to make the cell Range (A5:P6000) as my workable area. rest of the cells should be protected.

How can I do this using VB code in my Excel Sheet. Pls help me out.

Madhu

> > 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