Re: $$Excel-Macros$$ Re: Preventing opening a macro enabled excel file to be opened in OpenOffice or Similar opensource products

2013-08-01 Thread Aashish Watve
Thanks Lalit. Can you point me to any resource I can use to understand this?

Regards,
Aashish


On Thu, Aug 1, 2013 at 10:16 AM, Lalit Mohan Pandey 
mohan.pande...@gmail.com wrote:

 I am not sure about this becuse Microsoft excel vba doesn't work in
 Openoffice and if you really want to prevent your code then go for COM
 addin Using VSTO.


 On Wednesday, 31 July 2013 23:58:25 UTC+5:30, Aashish Watve wrote:

 Dear All,

 I have a very particular question. Is there a way to prevent opening a
 macro enabled excel spreadsheet being opened in OpenOffice products?

 One method suggested on some other forum was to check if the file is
 opened by excel application or other. If it is not excel then close it.

 1) How to check whether it is excel application or not?
 2) Will the hidden and protected worksheets remain hidden in Openoffice
 even if the macro doesn't run at the time of opening the file?

 Let me know, if someone has any experience in this.

 Aashish

  --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
 =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/groups/opt_out.




-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.




$$Excel-Macros$$ Re: Preventing opening a macro enabled excel file to be opened in OpenOffice or Similar opensource products

2013-07-31 Thread Lalit Mohan Pandey
I am not sure about this becuse Microsoft excel vba doesn't work in 
Openoffice and if you really want to prevent your code then go for COM 
addin Using VSTO.


On Wednesday, 31 July 2013 23:58:25 UTC+5:30, Aashish Watve wrote:

 Dear All,

 I have a very particular question. Is there a way to prevent opening a 
 macro enabled excel spreadsheet being opened in OpenOffice products?

 One method suggested on some other forum was to check if the file is 
 opened by excel application or other. If it is not excel then close it.

 1) How to check whether it is excel application or not?
 2) Will the hidden and protected worksheets remain hidden in Openoffice 
 even if the macro doesn't run at the time of opening the file?

 Let me know, if someone has any experience in this.

 Aashish


-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/groups/opt_out.