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: 189192 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Classes and Objects
Date: Wednesday, August 13, 2008 6:22:14 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
>
> >
> > 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.


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Range("A5:P6000").Value = ""
endsub

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