Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Automation with VFP - ReadOnly

Status
Not open for further replies.
mikeisvfp

mikeisvfp

Programmer
Mar 5, 2011
91
CA
Hello Experts
How would I make my excel workbook ReadOnly, I was only able to find "Mark As Final" which is ok, but i cant seem to get it to work

please help
 
Sort by date Sort by votes
You can either open it read-only by passing .T. for the 3rd parameter to the Open method, or make it "recommended read-only" by issuing SaveAs with the 5th parameter set to .T.

Note that, in Office, read-only simply means you can't save it back to the original file. It doesn't keep the user from making changes.

Tamar
 
Upvote 0 Downvote
Thank You Tamar

I figured out a safer way of doing this, rather than making escel file readonly

convert to pdf

oSheet.ExportAsFixedFormat(xlTypePDF, (mcExcelFile))


 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SitesMasstec
  • Question
A way to make all ReadOnly
Replies
12
Views
389
SitesMasstec
SitesMasstec
GriffMG
  • Question
Not Strictly VFP - Cracking Password on Excel Spreadsheet
Replies
6
Views
258
Chris Miller
Chris Miller
ravicoder
  • Locked
  • Question
excel automation printing to pdf error
Replies
8
Views
373
combo
combo
ravicoder
  • Locked
  • Question
Generating graphs using excel automation
Replies
1
Views
150
TamarGranor
TamarGranor
Premal Vala
  • Question
VFP with MYSQL - mySQL server gone away
Replies
8
Views
562
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top