Office Open XML Format?
in [General]
|
From: jfisk on 23 May 2007 11:05 In Excel 2007 we get the following warning: This document is both encypted and password protected. The Office Open XML Formats available in the 2007 release provide stronger encryption. Do you want to increase the security of this document by converting to an Office Open XML format? YES / NO How can I get rid of his? The file has a macro with hard set paths to the file name so I cannot save this in XLSX format or the macro will fail (and I would rather not rewrite the macro, as I have 50 people using this same sheet). Something in the registry perhaps?
From: Nick Hodge on 23 May 2007 16:14 Why can you not save as an xlsm? (Which is effectively why you are getting the message) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT(a)zen.co.ukANDTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "jfisk" <jfisk(a)discussions.microsoft.com> wrote in message news:D954F049-AA08-4BBE-931E-F714607F5982(a)microsoft.com... > In Excel 2007 we get the following warning: > This document is both encypted and password protected. The Office Open > XML > Formats available in the 2007 release provide stronger encryption. Do you > want to increase the security of this document by converting to an Office > Open XML format? > YES / NO > > How can I get rid of his? The file has a macro with hard set paths to the > file name so I cannot save this in XLSX format or the macro will fail (and > I > would rather not rewrite the macro, as I have 50 people using this same > sheet). Something in the registry perhaps?
From: jfisk on 23 May 2007 16:31 Because in a Macro I am hard calling the filename, it opens and closes the workbooks: "C:\EXAMPLE\Example.xls" does not equal C:\EXAMPLE\Example.xlsx "Nick Hodge" wrote: > Why can you not save as an xlsm? (Which is effectively why you are getting > the message) > > -- > HTH > Nick Hodge > Microsoft MVP - Excel > Southampton, England > nick_hodgeTAKETHISOUT(a)zen.co.ukANDTHIS > web: www.nickhodge.co.uk > blog (non-tech): www.nickhodge.co.uk/blog/ > "jfisk" <jfisk(a)discussions.microsoft.com> wrote in message > news:D954F049-AA08-4BBE-931E-F714607F5982(a)microsoft.com... > > In Excel 2007 we get the following warning: > > This document is both encypted and password protected. The Office Open > > XML > > Formats available in the 2007 release provide stronger encryption. Do you > > want to increase the security of this document by converting to an Office > > Open XML format? > > YES / NO > > > > How can I get rid of his? The file has a macro with hard set paths to the > > file name so I cannot save this in XLSX format or the macro will fail (and > > I > > would rather not rewrite the macro, as I have 50 people using this same > > sheet). Something in the registry perhaps? >
From: Nick Hodge on 23 May 2007 16:43 I do not know if you can stop this without changing lines in the macro. -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT(a)zen.co.ukANDTHIS web: www.nickhodge.co.uk blog (non-tech): www.nickhodge.co.uk/blog/ "jfisk" <jfisk(a)discussions.microsoft.com> wrote in message news:1B35C91C-CE6E-4903-9808-618D431FE853(a)microsoft.com... > Because in a Macro I am hard calling the filename, it opens and closes the > workbooks: "C:\EXAMPLE\Example.xls" does not equal > C:\EXAMPLE\Example.xlsx > > > "Nick Hodge" wrote: > >> Why can you not save as an xlsm? (Which is effectively why you are >> getting >> the message) >> >> -- >> HTH >> Nick Hodge >> Microsoft MVP - Excel >> Southampton, England >> nick_hodgeTAKETHISOUT(a)zen.co.ukANDTHIS >> web: www.nickhodge.co.uk >> blog (non-tech): www.nickhodge.co.uk/blog/ >> "jfisk" <jfisk(a)discussions.microsoft.com> wrote in message >> news:D954F049-AA08-4BBE-931E-F714607F5982(a)microsoft.com... >> > In Excel 2007 we get the following warning: >> > This document is both encypted and password protected. The Office Open >> > XML >> > Formats available in the 2007 release provide stronger encryption. Do >> > you >> > want to increase the security of this document by converting to an >> > Office >> > Open XML format? >> > YES / NO >> > >> > How can I get rid of his? The file has a macro with hard set paths to >> > the >> > file name so I cannot save this in XLSX format or the macro will fail >> > (and >> > I >> > would rather not rewrite the macro, as I have 50 people using this same >> > sheet). Something in the registry perhaps? >>
|
Pages: 1 Prev: data consolidation Next: The message EUROTOOL.XLA!fshow TTO Dialog cannot be found |