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 derfloh 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
Joined
Mar 5, 2011
Messages
91
Location
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

BugZap13
  • Locked
  • Question Question
Excel automation pastespecial getting OLE exception
Replies
3
Views
635
Chriss Miller
C
GTGeek88
  • Locked
  • Question Question
Signature pads with VFP
Replies
1
Views
854
tomk3
tomk3
Mandy_crw
  • Locked
  • Question Question
property showwindow is readonly error
Replies
6
Views
2K
Chris Miller
Chris Miller
dylim
  • Locked
  • Question Question
Latest VFP Version
Replies
15
Views
2K
Chriss Miller
C
C
  • Locked
  • Question Question
SQLEXEC crashes VFP
Replies
9
Views
1K
Claudio Costa
C

Part and Inventory Search

Sponsor

Back
Top