Prev: TextBox lock
Next: Leave Blank If No Data
From: stan on 25 Apr 2010 19:45
I am using a procedure that saves password-protected a 2007 excel file to a
folder. when I try to open it I get the message:

"excel cannot open the file because the file format or file extention is not
valid,,,"

I was told that making the folder a "trusted location" will prevent file
format blocking but that doesn't seem to work either. Nor does changing to
other 2007 extensions, including xlsb.

anyone have any ideas?
--
stan
From: Ms-Exl-Learner on 25 Apr 2010 22:02
In which format (extension) your procedure is saving the excel file? In
*.XLS, *.XLSX, *.XLSM Or *.XLSB?

At the same time assume that if the file is saved in 2003 file format and by
changing the File Type from *.XLS to *.XLSX, *.XLSM Or *.XLSB will not cause
excel to treat it as 2007 file. It should be converted by using Saveas
button instead of changing the file type manually.

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"stan" wrote:

> I am using a procedure that saves password-protected a 2007 excel file to a
> folder. when I try to open it I get the message:
>
> "excel cannot open the file because the file format or file extention is not
> valid,,,"
>
> I was told that making the folder a "trusted location" will prevent file
> format blocking but that doesn't seem to work either. Nor does changing to
> other 2007 extensions, including xlsb.
>
> anyone have any ideas?
> --
> stan
From: stan on 26 Apr 2010 09:49
The file is initially xls but saveas is used to save it as xlsx. I still get
the message.
--
stan


"Ms-Exl-Learner" wrote:

> In which format (extension) your procedure is saving the excel file? In
> *.XLS, *.XLSX, *.XLSM Or *.XLSB?
>
> At the same time assume that if the file is saved in 2003 file format and by
> changing the File Type from *.XLS to *.XLSX, *.XLSM Or *.XLSB will not cause
> excel to treat it as 2007 file. It should be converted by using Saveas
> button instead of changing the file type manually.
>
> Remember to Click Yes, if this post helps!
>
> --------------------
> (Ms-Exl-Learner)
> --------------------
>
>
> "stan" wrote:
>
> > I am using a procedure that saves password-protected a 2007 excel file to a
> > folder. when I try to open it I get the message:
> >
> > "excel cannot open the file because the file format or file extention is not
> > valid,,,"
> >
> > I was told that making the folder a "trusted location" will prevent file
> > format blocking but that doesn't seem to work either. Nor does changing to
> > other 2007 extensions, including xlsb.
> >
> > anyone have any ideas?
> > --
> > stan
 | 
Pages: 1
Prev: TextBox lock
Next: Leave Blank If No Data