[NF] Excel protection question

2007-06-07 Thread MB Software Solutions
I created an Excel output from VFP using the COPY TO ... TYPE XL5 
command.  I'd like the user to be able to enter data in a single column 
(let's say Column E) but have every other column protected so that the 
user can't change that data, nor allow the user to add/remove rows. 

Is this possible to achieve (and all programatically from VFP)?

-- 
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: [NF] Excel protection question

2007-06-07 Thread Ted Roche
On 6/7/07, MB Software Solutions [EMAIL PROTECTED] wrote:

 Is this possible to achieve (and all programatically from VFP)?

Yup. Got a copy of Office Automation from Hentzenwerke? pp 203-204.

Don't have it? You can download the PDF in seconds -- order from
www.hentzenwerke.com

-- 
Ted Roche
Ted Roche  Associates, LLC
http://www.tedroche.com


___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


Re: [NF] Excel protection question

2007-06-07 Thread MB Software Solutions
Ted Roche wrote:
 On 6/7/07, MB Software Solutions [EMAIL PROTECTED] wrote:

   
 Is this possible to achieve (and all programatically from VFP)?
 

 Yup. Got a copy of Office Automation from Hentzenwerke? pp 203-204.

 Don't have it? You can download the PDF in seconds -- order from
 www.hentzenwerke.com

   
Thanks, TR!

-- 
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!



___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.


RE: [NF] Excel protection question

2007-06-07 Thread Dave Crozier
Michael,
This creates a readwrite column and a readonly column

Dave Crozier


oExcel=Createobject(Excel.Application)
With oExcel
.Visible=.T.
.Workbooks.Add()

oSheet=.ActiveSheet

With oSheet
.Range(A1:A2).Select
.Cells(1,1).Value=Readwrite
.Range(A1:A2).Locked=.F.

.Range(B1:B2).Select
.Cells(1,2).Value=Readonly
.Range(B1:B2).Locked=.T.

.Protect(,,.T.)
*
Endwith
*
Endwith


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of MB Software Solutions
Sent: 07 June 2007 13:57
To: Profox
Subject: [NF] Excel protection question

I created an Excel output from VFP using the COPY TO ... TYPE XL5 
command.  I'd like the user to be able to enter data in a single column 
(let's say Column E) but have every other column protected so that the 
user can't change that data, nor allow the user to add/remove rows. 

Is this possible to achieve (and all programatically from VFP)?

-- 
Michael J. Babcock, MCP
MB Software Solutions, LLC
http://mbsoftwaresolutions.com
http://fabmate.com
Work smarter, not harder, with MBSS custom software solutions!



[excessive quoting removed by server]

___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED]
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.