View Full Version : restrict a excel file opened open office
MaayanSV
03-26-2010, 02:55 AM
Hi,
is there any possibilty to restrict a user to open a excel file in open office application?
:banghead: :banghead: :banghead:
thanks in advance,
maayan
Check for Application = various Excel codes in Workbook Open event
MaayanSV
03-26-2010, 05:06 AM
here the problem is not the excel code.
when i open this file, code in this file will guide the user to update the workbook with desired process.
when it is opened in other application this code will become dead and leaves a way to update the workbook in undesirable manner.
it will really help me a lot if anyone help me with a peace of code to restrict this.
You're going to have to program VBA for Open Office.
http://www.kalitech.fr/clients/doc/VB_APIOOo_en.html
http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide
http://www.pitonyak.org/oo.php
http://udk.openoffice.org/common/man/tutorial/office_automation.html
And, of Course, Google:
http://www.google.com/search?hl=en&q=automate+openoffice+%2BVBA&aq=f&aqi=&aql=f&oq=&gs_rfai=
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.