$$Excel-Macros$$ Re: Different behaviour between opening xls and xlsx files

1:32 am, Paul Schreiner wrote: > Curios. > Because I saved some files in .xls format and .xlsx format with and without > passwords. > When I opened them with my macro, it didn't pop up a panel, > but DID issue the "Could not open" message. > > I'll have to t

$$Excel-Macros$$ Re: Different behaviour between opening xls and xlsx files

ifferently than yours. P - Original Message > From: Wazza > To: MS EXCEL AND VBA MACROS > Sent: Monday, January 26, 2009 8:48:59 PM > Subject: $$Excel-Macros$$ Re: Different behaviour between opening xls and > xlsx files > > > Paul, > > If you attempt your approac

$$Excel-Macros$$ Re: Different behaviour between opening xls and xlsx files

Paul, If you attempt your approach without the 'Password:="password"' parameter AND if the file has an open password then Excel will throw up a dialog box asking for the password, no matter that you have specified Application.DisplayAlerts = False. That is the express reason why I include the pa

$$Excel-Macros$$ Re: Different behaviour between opening xls and xlsx files

I believe this is enhance security in MS Excel 2007. Regards, Sarfaraz Ahmed Free MS Excel help On Thu, Jan 22, 2009 at 10:19 AM, Wazza wrote: > > I have an application that opens Excel files and loads data into an > Access database. This app runs unattended an

$$Excel-Macros$$ Re: Different behaviour between opening xls and xlsx files

I tested this: Sub Test()     Application.DisplayAlerts = False     On Error Resume Next     Err.Clear     Set wkb = Excel.Workbooks.Open(Filename:="C:\temp\test.xlsx" _     , ReadOnly:=True, Password:="password")     If (Err.Number > 0) Then     MsgBox "Could not open"     End If